﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>语源科技BlogJava-枫中畅游</title><link>http://www.blogjava.net/javalinjx/</link><description>关注技术，热爱生活</description><language>zh-cn</language><lastBuildDate>Sun, 12 Apr 2026 06:03:43 GMT</lastBuildDate><pubDate>Sun, 12 Apr 2026 06:03:43 GMT</pubDate><ttl>60</ttl><item><title>linux系统之上搭建maven 之nexus服务篇</title><link>http://www.blogjava.net/javalinjx/archive/2013/08/21/403110.html</link><dc:creator>javalinjx</dc:creator><author>javalinjx</author><pubDate>Wed, 21 Aug 2013 01:32:00 GMT</pubDate><guid>http://www.blogjava.net/javalinjx/archive/2013/08/21/403110.html</guid><wfw:comment>http://www.blogjava.net/javalinjx/comments/403110.html</wfw:comment><comments>http://www.blogjava.net/javalinjx/archive/2013/08/21/403110.html#Feedback</comments><slash:comments>2</slash:comments><wfw:commentRss>http://www.blogjava.net/javalinjx/comments/commentRss/403110.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/javalinjx/services/trackbacks/403110.html</trackback:ping><description><![CDATA[<div style="margin-bottom: 15px; font-family: Helvetica, Tahoma, Arial, sans-serif; font-size: 12px; line-height: 18px;"><h3><span style="line-height: 1.8em;"><span style="font-weight: normal;">&nbsp; &nbsp; &nbsp; &nbsp;今天刚好有点时间，就想在公司的服务器搭建一个私服，以便以后可以唯我所用，当然前提是服务器最好可以上网，否则还需要配置代理服务器，前两天刚好把服务器的网络给配置了下，这边就不详述了！大家一定着急了吧，稍安务燥，这就进入正题，O(&#8745;_&#8745;)O~</span></span></h3></div><div id="blog_content" style="line-height: 1.8em; font-family: Helvetica, Tahoma, Arial, sans-serif;"><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; linux安装过程和window主机还是差别挺大的。</p><p style="margin: 0px; padding: 0px;"><strong>1.下载nexus集成版</strong></p><p style="margin: 0px; padding: 0px;">到这个地方<a href="http://www.sonatype.org/nexus/go" style="color: #108ac6; line-height: 1.5;">http://www.sonatype.org/nexus/go</a>&nbsp;下载压缩包，我这边下载的是nexus-2.0.3-bundle.tar.gz这个版本。</p><p style="margin: 0px; padding: 0px;"><strong>2. 解压到相应的目录</strong></p><p style="margin: 0px; padding: 0px;">tar &nbsp;-xzvf &nbsp;nexus-2.0.3-bundle.tar.gz ， 我这边放在/home/linjx/opendev/nexus-2.0.3目录下。</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;"><strong>3. 设置为系统服务</strong></p><p style="margin: 0px; padding: 0px;">这里需要使用root权限，具体请看<a href="http://books.sonatype.com/nexus-book/reference/install-sect-service.html" style="color: #108ac6; line-height: 1.5;">http://books.sonatype.com/nexus-book/reference/install-sect-service.html</a></p><p style="margin: 0px; padding: 0px;">简单如下：</p><p style="margin: 0px; padding: 0px;"># cd &nbsp;/etc/init.d</p><p style="margin: 0px; padding: 0px;"># cp &nbsp;/home/linjx/opendev/nexus-2.0.3/bin/jsw/linux-x86-64/nexus ./nexus</p><p style="margin: 0px; padding: 0px;"># chmod 755 nexus</p><p style="margin: 0px; padding: 0px;"># chkconfig --add nexus</p><p style="margin: 0px; padding: 0px;"># chkconfig --levels 345 nexus on</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;"><strong>4.&nbsp;</strong><strong>编辑/etc/init.d/nexus</strong><strong>的文本</strong></p><p style="margin: 0px; padding: 0px;">4.1. 添加以下变量</p><p style="margin: 0px; padding: 0px;">RUN_AS_USER=linjx &nbsp; &nbsp;## 这个主要为了后面使用，不需要使用root用户启动服务</p><p style="margin: 0px; padding: 0px;">NEXUS_HOME=/home/linjx/opendev/nexus-2.0.3/</p><p style="margin: 0px; padding: 0px;">PLATFORM=linux-x86-64</p><p style="margin: 0px; padding: 0px;">PLATFORM_DIR="${NEXUS_HOME}/bin/jsw/${PLATFORM}"</p><p style="margin: 0px; padding: 0px;">4.2. 修改以下变量</p><p style="margin: 0px; padding: 0px;">WRAPPER_CMD="${PLATFORM_DIR}/wrapper"</p><p style="margin: 0px; padding: 0px;">WRAPPER_CONF="${PLATFORM_DIR}/../conf/wrapper.conf"</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">PIDDIR="${NEXUS_HOME}"</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;"><strong>5. 启动服务</strong></p><p style="margin: 0px; padding: 0px;">切换会自己的用户，不需要使用root用户；</p><p style="margin: 0px; padding: 0px;"># service nexus start</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">这个大家出现什么情况，是不是失败了！界面上出现 ：Could not write pid file /etc/rc.d/init.d/./nexus.pid: Permission denied通过查看日志文件：</p><p style="margin: 0px; padding: 0px;">fzdev#[/home/linjx/opendev/nexus-2.0.3/logs] cat w* &nbsp;</p><p style="margin: 0px; padding: 0px;">wrapper &nbsp;| ERROR: Could not write pid file /etc/rc.d/init.d/./nexus.pid: Permission denied</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">怎么办呢，根据信息提示，nexus.pid无法写入，应该还是权限问题，这个应该跟启动当前服务有关。</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">查文档<a href="http://books.sonatype.com/nexus-book/reference/install-sect-service.html" style="color: #108ac6; font-size: 12px; line-height: 1.5;">http://books.sonatype.com/nexus-book/reference/install-sect-service.html</a>后发现，一有段信息没有配置，</p><p style="margin: 0px; padding: 0px;">Change PIDDIR to a directory where this user has read/write permissions. In most Linux distributions, /var/run is only writable by root. The properties you need to add to customize the PID file location is "wrapper.pid". For more information about this property and how it would be configured in wrapper.conf, see:&nbsp;<a target="_top" href="http://wrapper.tanukisoftware.com/doc/english/properties.html" style="color: #0088cc; line-height: 1.4em; font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 16px;">http://wrapper.tanukisoftware.com/doc/english/properties.html</a></p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">大概意思就是服务启动时无法写入pid，就是说init.d这个目录当前用户是没有权限写的，怎么办呢。可以自定义pid写入目录，那么在哪里配置呢，是不是又想起了wrapper.conf了，其他文档中也说明了。</p><p style="margin: 0px; padding: 0px;">好吧，那就再加个配置吧，这样：PIDDIR="/home/linjx/piddir"</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">然后再启动服务，果然成功了！具体可以看看附件中的详细的日志！</p><p style="margin: 0px; padding: 0px;"><br /><img alt="" src="http://dl2.iteye.com/upload/attachment/0088/2747/6313fa03-5d0a-379d-92ad-2d104f79627f.jpg" title="点击查看原始大小图片" width="699" height="294" style="border: 0px; cursor: url(http://www.iteye.com/images/magplus.gif), pointer;" /><br />&nbsp;</p><p style="margin: 0px; padding: 0px;"><strong>6.&nbsp;</strong><strong>启动之后，可以登录首页查看nexus的界面</strong><strong><br /></strong></p><p style="margin: 0px; padding: 0px;">http://192.168.1.26:8081/nexus/index.html</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">默认管理员用户名/密码: admin/admin123</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;"><br /><img alt="" src="http://dl2.iteye.com/upload/attachment/0088/2749/3706bc1b-5c60-314b-b7d1-cf87d056c810.jpg" title="点击查看原始大小图片" width="700" height="316" style="border: 0px; cursor: url(http://www.iteye.com/images/magplus.gif), pointer;" /><br />&nbsp;</p></div><img src ="http://www.blogjava.net/javalinjx/aggbug/403110.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/javalinjx/" target="_blank">javalinjx</a> 2013-08-21 09:32 <a href="http://www.blogjava.net/javalinjx/archive/2013/08/21/403110.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>使用leiningen搭建clojure开发环境</title><link>http://www.blogjava.net/javalinjx/archive/2013/07/03/401170.html</link><dc:creator>javalinjx</dc:creator><author>javalinjx</author><pubDate>Wed, 03 Jul 2013 05:40:00 GMT</pubDate><guid>http://www.blogjava.net/javalinjx/archive/2013/07/03/401170.html</guid><wfw:comment>http://www.blogjava.net/javalinjx/comments/401170.html</wfw:comment><comments>http://www.blogjava.net/javalinjx/archive/2013/07/03/401170.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/javalinjx/comments/commentRss/401170.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/javalinjx/services/trackbacks/401170.html</trackback:ping><description><![CDATA[<div style="margin-bottom: 15px; font-family: Helvetica, Tahoma, Arial, sans-serif; font-size: 12px; line-height: 18px;"><h3><span style="line-height: 1.8em;">首先来讲下Leiningen是什么东东？</span></h3></div><div id="blog_content" style="line-height: 1.8em; font-family: Helvetica, Tahoma, Arial, sans-serif;"><p style="margin: 0px; padding: 0px;">Leiningen是一个用于自动化（构建）clojure项目的工具。</p><p style="margin: 0px; padding: 0px;">它可以做到：</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 创建新项目</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 管理你的项目的依赖关系</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 运行测试</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 运行一个REPL(读取-求值-打印循环:read-eval-print loop)</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 编译java源码</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 运行项目</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 为项目产生一个Maven风格的POM文件</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 为了部署，编译和打包项目</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 发布类库到Maven仓库，例如Clojars</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 运行Clojure编写的自定义的自动化任务（称为Leiningen插件）</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; ... 具体可以查看国内的大牛(killme2008)翻译的<a href="http://wiki.fnil.net/index.php?title=Leiningen_tutorial%E4%B8%AD%E6%96%87%E7%89%88" style="color: #108ac6;">Leiningen教程中文版</a>的详细介绍。</p><p style="margin: 0px; padding: 0px;">好些话说多了点，大家别着急啊，马上就切入主题：</p><p style="margin: 0px; padding: 0px;">1. 下载安装Leiningen</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp;linux:&nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; 1. 确保你是jdk 6 版本以下的。</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; 2.&nbsp;<a href="https://raw.github.com/technomancy/leiningen/stable/bin/lein" title="lein" target="_blank" style="color: #108ac6;">下载脚本lein</a></p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; 3. 把lein加入下当前的$path下（~/bin 是最好的选择）</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; 4. 赋可执行权限（chmod 755 ~/bin/lein）</p><p style="margin: 0px; padding: 0px;">&nbsp; windows:</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; 1. 可以直接下载打包好的文件，地址是：<a href="https://bitbucket.org/djpowell/leiningen-win-installer/downloads/leiningen-installer-beta1.exe" target="_blank" style="color: #108ac6;">Leiningen for windows</a></p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; 2. 点击下载好的*.exe文件进行安装</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; 3. 安装好后，可以查看环境变量中会有相应的变量被设置好了：</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;lein.bat is added to your PATH variable.</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; LEIN_JAVA_CMD&nbsp;is set to point to your selected JDK, and the&nbsp;:java-cmd&nbsp;property is set in your &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;user profile in&nbsp;profiles.clj.</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; 接下来，打开命令窗口，输入命令：lein self-install &nbsp;，会自动下载安装leiningen 相关的jar文件。</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp;验证下安装成果： 在命令窗口中输入lein repl ，会自动连上nREPL server，进入repl模式，如下所示：</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp;&nbsp;</p><div id="" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word;"><div><div style="padding-right: 3px; padding-bottom: 3px; padding-left: 3px; margin: 0px; font-weight: bold;">Shell代码&nbsp;<embed wmode="transparent" src="http://javalinjx.iteye.com/javascripts/syntaxhighlighter/clipboard_new.swf" width="14" height="15" flashvars="clipboard=C%3A%5CUsers%5Clinjx%3Elein%20repl%0AnREPL%20server%20started%20on%20port%2021912%0AREPL-y%200.2.0%0AClojure%201.5.1%0A%20%20%20%20Docs%3A%20(doc%20function-name-here)%0A%20%20%20%20%20%20%20%20%20%20(find-doc%20%22part-of-name-here%22)%0A%20%20Source%3A%20(source%20function-name-here)%0A%20Javadoc%3A%20(javadoc%20java-object-or-class-here)%0A%20%20%20%20Exit%3A%20Control%2BD%20or%20(exit)%20or%20(quit)%0A%0Auser%3D%3E" quality="high" allowscriptaccess="always" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer">&nbsp;<a href="" title="收藏这段代码" style="color: #108ac6;"><img src="http://javalinjx.iteye.com/images/icon_star.png" alt="收藏代码" style="border: 0px;" /></a></div></div><ol start="1" style="font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border: 1px solid #d1d7dc; color: #2b91af;"><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">C:\Users\linjx&gt;lein&nbsp;repl&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">nREPL&nbsp;server&nbsp;started&nbsp;on&nbsp;port&nbsp;<span style="color: #c00000;">21912</span>&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">REPL-y&nbsp;<span style="color: #c00000;">0.2</span>.<span style="color: #c00000;">0</span>&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">Clojure&nbsp;<span style="color: #c00000;">1.5</span>.<span style="color: #c00000;">1</span>&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">&nbsp;&nbsp;&nbsp;&nbsp;Docs:&nbsp;(doc&nbsp;function-name-here)&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(find-doc&nbsp;"part-of-name-here")&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">&nbsp;&nbsp;Source:&nbsp;(source&nbsp;function-name-here)&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">&nbsp;Javadoc:&nbsp;(javadoc&nbsp;java-object-or-class-here)&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">&nbsp;&nbsp;&nbsp;&nbsp;Exit:&nbsp;Control+D&nbsp;or&nbsp;(exit)&nbsp;or&nbsp;(quit)&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">user=&gt;&nbsp;&nbsp;</li></ol></div><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 如果出现上面的提示，则说明leiningen安装成功，你可以在使用leiningen开发你的clojure之旅了。</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; 但是往往我们不满足于现状，希望可以更有效的使用lein编写clojure。类似java的idea,eclipse一样，都对编写java提供了强大的工具，那么我们可以选择什么样的工具呢，毫无疑问，Emacs是最合适的工具，没有之一：）</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp;对于我这断断续续学习emacs的来说，还真不是不容易，昨晚查看了相关的e文说明，在emacs中成功装配了nrepl ，用以后续的开发学习，便记录一下，希望对自己以后查阅，以及需要的人有所帮助。</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp;首先，我本地有emacs 24 版本的， 这里不想讲emacs 的安装，这个大家自个儿查询下google便可以了。</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp;在安装好leiningen之后，现在进入<a href="https://github.com/kingtim/nrepl.el" style="color: #108ac6;">nrepl</a>的主页看看，这是个什么东东！</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp;nrepl.el is an Emacs client for nREPL,the Clojre networked REPL server.It's a great alternative to the now deprecated combination fo SLIME + swank-clojure.</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; nrepl.el是emacs作为nrepl的一个客户端，nrepl是一个反对目前slime+swank-clojure组合的最好的替代品。</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp;下面来看下如何安装nrepl.el：</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; 1. emacs 24 以及更高版本是构建在package.el之上的，但是emacs 23以下版本的，你需要自己获取<a href="http://repo.or.cz/w/emacs.git/blob_plain/1a0a666f941c99882093d7bd08ced15033bc3f0c:/lisp/emacs-lisp/package.el" style="color: #108ac6;">package.el</a>&nbsp;.</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; 虽然我的是24版本的，但是我也下载了package.el，并存放在 &nbsp; &nbsp; C:\Users\linjx\AppData\Roaming\.emacs.d 目前下，这个是我的emacs在windows下的配置目录。</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; 2. 这里需要提一个文件，即&nbsp;.emacs 文件，这个是emacs初始化配置的文件，位于C:\Users\linjx\AppData\Roaming 目录下。</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;如果你不需要使用Marmalade,则添加配置 到 .emacs文件中，如下所示：</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><div id="" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word;"><div><div style="padding-right: 3px; padding-bottom: 3px; padding-left: 3px; margin: 0px; font-weight: bold;">Lisp代码&nbsp;<embed wmode="transparent" src="http://javalinjx.iteye.com/javascripts/syntaxhighlighter/clipboard_new.swf" width="14" height="15" flashvars="clipboard=(require%20'package)%0A(add-to-list%20'package-archives%0A%20%20%20%20%20%20%20%20%20%20%20%20%20'(%22marmalade%22%20.%20%22http%3A%2F%2Fmarmalade-repo.org%2Fpackages%2F%22))%0A(package-initialize)" quality="high" allowscriptaccess="always" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer">&nbsp;<a href="" title="收藏这段代码" style="color: #108ac6;"><img src="http://javalinjx.iteye.com/images/icon_star.png" alt="收藏代码" style="border: 0px;" /></a></div></div><ol start="1" style="font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border: 1px solid #d1d7dc; color: #2b91af;"><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">(require&nbsp;'package)&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">(add-to-list&nbsp;'package-archives&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'("marmalade"&nbsp;.&nbsp;"http://marmalade-repo.org/packages/"))&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">(package-initialize)&nbsp;&nbsp;</li></ol></div><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp;由于使用MELPA the code ，需要添加配置到 .emacs文件中，</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp;</p><div id="" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word;"><div><div style="padding-right: 3px; padding-bottom: 3px; padding-left: 3px; margin: 0px; font-weight: bold;">Lisp代码&nbsp;<embed wmode="transparent" src="http://javalinjx.iteye.com/javascripts/syntaxhighlighter/clipboard_new.swf" width="14" height="15" flashvars="clipboard=(require%20'package)%0A(add-to-list%20'package-archives%0A%20%20%20%20%20%20%20%20%20%20%20%20%20'(%22melpa%22%20.%20%22http%3A%2F%2Fmelpa.milkbox.net%2Fpackages%2F%22)%20t)%0A(package-initialize)" quality="high" allowscriptaccess="always" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer">&nbsp;<a href="" title="收藏这段代码" style="color: #108ac6;"><img src="http://javalinjx.iteye.com/images/icon_star.png" alt="收藏代码" style="border: 0px;" /></a></div></div><ol start="1" style="font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border: 1px solid #d1d7dc; color: #2b91af;"><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">(require&nbsp;'package)&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">(add-to-list&nbsp;'package-archives&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;'("melpa"&nbsp;.&nbsp;"http://melpa.milkbox.net/packages/")&nbsp;t)&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">(package-initialize)&nbsp;&nbsp;</li></ol></div><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp; 在emacs中打开.emacs文件，并M-x eval-buffer，执行当前的配置。</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp;&nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp;3. &nbsp;刷新配置</p><div id="" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word;"><div><div style="padding-right: 3px; padding-bottom: 3px; padding-left: 3px; margin: 0px; font-weight: bold;">Lisp代码&nbsp;<embed wmode="transparent" src="http://javalinjx.iteye.com/javascripts/syntaxhighlighter/clipboard_new.swf" width="14" height="15" flashvars="clipboard=M-x%20package-refresh-contents%20%20%E5%9B%9E%E8%BD%A6" quality="high" allowscriptaccess="always" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer">&nbsp;<a href="" title="收藏这段代码" style="color: #108ac6;"><img src="http://javalinjx.iteye.com/images/icon_star.png" alt="收藏代码" style="border: 0px;" /></a></div></div><ol start="1" style="font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border: 1px solid #d1d7dc; color: #2b91af;"><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">M-x&nbsp;package-refresh-contents&nbsp;&nbsp;回车&nbsp;&nbsp;</li></ol></div><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp;emacs会自动下载安装Marmalade , melpa相关的配置；</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp;4. 安装nrepl</p><p style="margin: 0px; padding: 0px;">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;输入命令&nbsp;</p><div id="" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word;"><div><div style="padding-right: 3px; padding-bottom: 3px; padding-left: 3px; margin: 0px; font-weight: bold;">命令代码&nbsp;<embed wmode="transparent" src="http://javalinjx.iteye.com/javascripts/syntaxhighlighter/clipboard_new.swf" width="14" height="15" flashvars="clipboard=M-x%20package-install%20%E5%9B%9E%E8%BD%A6%0A%20%20%20%20%20%20%20nrepl%20%E5%9B%9E%E8%BD%A6" quality="high" allowscriptaccess="always" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer">&nbsp;<a href="" title="收藏这段代码" style="color: #108ac6;"><img src="http://javalinjx.iteye.com/images/icon_star.png" alt="收藏代码" style="border: 0px;" /></a></div></div><ol start="1" style="font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border: 1px solid #d1d7dc; color: #2b91af;"><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">M-x&nbsp;package-install&nbsp;回车&nbsp;&nbsp;</li><li style="font-size: 1em; margin-left: 38px; padding-right: 0px; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;nrepl&nbsp;回车&nbsp;&nbsp;</li></ol></div><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">&nbsp;&nbsp; &nbsp; 致此，nrepl集成到emacs的安装完毕，可以使用emacs开发你的hello world！了。</p><p style="margin: 0px; padding: 0px;">( 当然，emacs还可以与其他集成用来clojure的开发，这里我就不详述了，毕竟没有使用！）</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">现在我们使用lein new 一个clojure项目出来：</p><p style="margin: 0px; padding: 0px;">1. $ &nbsp;lein new hello</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">2. 打开emacs，在buffer中打开 hello所在的目录下的project.clj文件</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">3. 输入命令：M-x nrepl-jack-in，即可初始化一个nrepl server &nbsp;和 nrepl client</p><p style="margin: 0px; padding: 0px;">如下图所示：</p><p style="margin: 0px; padding: 0px;"><br /><img src="http://dl2.iteye.com/upload/attachment/0086/4648/dfe266e5-6ed1-3746-9e45-e0d64a3f5917.jpg" alt="" style="border: 0px;" /><br />&nbsp;<br /><img src="http://dl2.iteye.com/upload/attachment/0086/4650/b9ef274b-c25a-3b04-9a6f-9862ca305608.jpg" alt="" style="border: 0px;" /><br />&nbsp;<br /><img src="http://dl2.iteye.com/upload/attachment/0086/4652/834514a5-31fc-3287-a88b-8fabd9d92849.jpg" alt="" style="border: 0px;" /></p></div><img src ="http://www.blogjava.net/javalinjx/aggbug/401170.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/javalinjx/" target="_blank">javalinjx</a> 2013-07-03 13:40 <a href="http://www.blogjava.net/javalinjx/archive/2013/07/03/401170.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>git命令记录</title><link>http://www.blogjava.net/javalinjx/archive/2013/07/03/401167.html</link><dc:creator>javalinjx</dc:creator><author>javalinjx</author><pubDate>Wed, 03 Jul 2013 04:18:00 GMT</pubDate><guid>http://www.blogjava.net/javalinjx/archive/2013/07/03/401167.html</guid><wfw:comment>http://www.blogjava.net/javalinjx/comments/401167.html</wfw:comment><comments>http://www.blogjava.net/javalinjx/archive/2013/07/03/401167.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/javalinjx/comments/commentRss/401167.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/javalinjx/services/trackbacks/401167.html</trackback:ping><description><![CDATA[<div style="margin-bottom: 15px; font-family: Helvetica, Tahoma, Arial, sans-serif; font-size: 12px; line-height: 18px;"><h3><span style="line-height: 1.8em;">从服务器创建一个本地仓库的clone版本：</span></h3></div><div id="blog_content" style="line-height: 1.8em; font-family: Helvetica, Tahoma, Arial, sans-serif;"><p style="margin: 0px; padding: 0px;">git clone /path/to/repository</p><p style="margin: 0px; padding: 0px;">如果是远端服务器上的仓库，你的命令是这样：</p><p style="margin: 0px; padding: 0px;">git clone username@host:/path/to/repository</p><p style="margin: 0px; padding: 0px;">多种方式的URI</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">git add &lt;filename&gt;</p><p style="margin: 0px; padding: 0px;">git add *</p><p style="margin: 0px; padding: 0px;">git commit -m "代码提交信息"</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">将本地仓库的head中的东西提交到远程服务器上：</p><p style="margin: 0px; padding: 0px;">git push origin master(分支名)</p><p style="margin: 0px; padding: 0px;">欲将本地的仓库连接到某个远程服务器</p><p style="margin: 0px; padding: 0px;">git remote add origin &lt;server&gt;</p><p style="margin: 0px; padding: 0px;">&nbsp;</p><p style="margin: 0px; padding: 0px;">持续补充，作为自己查询使用</p></div><img src ="http://www.blogjava.net/javalinjx/aggbug/401167.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/javalinjx/" target="_blank">javalinjx</a> 2013-07-03 12:18 <a href="http://www.blogjava.net/javalinjx/archive/2013/07/03/401167.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Junit 学习笔记 </title><link>http://www.blogjava.net/javalinjx/archive/2013/06/17/400624.html</link><dc:creator>javalinjx</dc:creator><author>javalinjx</author><pubDate>Mon, 17 Jun 2013 01:52:00 GMT</pubDate><guid>http://www.blogjava.net/javalinjx/archive/2013/06/17/400624.html</guid><wfw:comment>http://www.blogjava.net/javalinjx/comments/400624.html</wfw:comment><comments>http://www.blogjava.net/javalinjx/archive/2013/06/17/400624.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/javalinjx/comments/commentRss/400624.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/javalinjx/services/trackbacks/400624.html</trackback:ping><description><![CDATA[<p style="margin: 0px; padding: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25.1875px; background-color: #ffffff;">上周空闲，看完了《单元测试之道》，这里对自己的学习做个小结，以便以后查阅：&nbsp;</p><p style="margin: 0px; padding: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25.1875px; background-color: #ffffff;">&nbsp;</p><div style="font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25.1875px; background-color: #ffffff;"><div><strong>一般原则：</strong></div><div>测试任何可能失败的地方。</div><div>测试任何已经失败的地方。</div><div>对于新加的代码，在被证明正确之前，都可能是有问题的。</div><div>至少编写和产品代码一样多的测试代码。</div><div>针对每次编译都做局部测试。</div><div>签入代码之前做全局测试。</div><div><strong>需要回答的问题：</strong></div><div>我如何知道代码运行是否正确呢？</div><div style="padding-left: 30px; font-family: Tahoma; line-height: normal; font-size: medium;">我要如何对它进行测试？</div><div>还有哪些方面可能会发生错误？</div><div>这个问题是否会在其他的地方出现呢？</div><div><strong>测试哪些方面 ：使用junit 测试的6个方面，统称为：Right-BICEP:</strong></div><div>Right －－－ 结果是否正确？</div><div>B －－－ 是否所有的边界条件都是正确？</div><div>I －－－ 能查一下反向关联吗？</div><div>C －－－ 能用其他手段交叉检查一下结果吗？</div><div>E －－－ 你是否可以强制错误条件发生？</div><div>P －－－ 是否满足性能要求？</div><div><strong>编写测试用例原则，correct边界条件：</strong></div><div>conformance （一致性）－－ 值 是否和预期的一致。</div><div>Ordering（顺序性）－－一组值是该有序或者无序的。</div><div>Range（区间性）－－值是否位于合理的最小值和最大值之内。</div><div>Reference（引用 、耦合性）－－代码是否引用了一些不在代码本身控制范围之内的外部资源。</div><div>Existence（存在性）－－值是否存在（例如，是否是非null，非0，在一个集合中等等）。</div><div>Cardinatity（基数性）－－是否恰好有足够的值？</div><div>Time（相对或者绝对的时间性）－－所有事情的发生是否是有序的？是否是在正确的时刻？是否恰好及时？</div><div><strong>环境方面的因素：</strong></div><div>内存耗光。</div><div>磁盘用满。</div><div>时钟出问题。</div><div>网络不可用或者有问题。</div><div>系统过载。</div><div>调色板颜色数目有限。</div><div>显示分辨率过高或者过低。</div><div><span style="color: #ff0000;">0－1－n 原则</span></div><div><strong>Mock对象：</strong></div><div>真实对象具有不可确定的行为（产生不可预测的结果，如股票行情）</div><div>真实对象很难被创建</div><div>真实对象的某些行为很难触发（如网络错误）。</div><div>真实对象令程序的运行速度很慢。</div><div>真实对象有（或者是）用户界面。</div><div>测试需要询问真实对象它是如何被调用的（例如，测试可能需要验证某个回调函数是否被调用了）。</div><div>真实对象实际上并不存在（当需要和其他开发小组，或者新的硬件系统打交道的时候，这是一个普遍问题）。</div><div><span style="color: #0000ff;">借助于mock对象，我们就可以解决上面提到的所有问题。在使用mock对象进行测试的时候，总共有3个步骤，分别是：</span></div><div>1. 使用一个接口来描述这个对象。</div><div>2. 为产品代码实现这个接口。</div><div>3. 以测试为目的，在mock对象中实现这个接口。</div><div>mock提供了所有系统功能的现成接口，所以在更多的时候，人们可能（也许吧）会使用它而不是直接调用诸如System.currentTimeMillis()这样的东西，而是躲在接口背后拥有了控制一切行为的能力。</div><div>这就是mock对象的全部；伪装出真实世界的某些部分，使你可以集中精力测试好自己编写的代码。让我们接下来看看更加复杂的例子吧。</div><div><strong>好的测试是一个A－TPIP：</strong></div><div>1. 自动化 (Automatic). &nbsp;调用测试自动化和检查结果自动化。</div><div>2. 彻底的 (Thorough).</div><div>3. 可重复 (Repeatable).</div><div>4. 独立的 (Independent).</div><div>5. 专业的 (Professional).</div><div><strong>在你发现bug时，所需要做的就是以下四个步骤：</strong></div><div>1.验明bug；</div><div>2.编写一个将失败的测试来证明bug的存在。</div><div>3.修正代码，让测试通过。</div><div>4.验证所有的测试仍然可以通过（也就是，你没有在修补的时候损坏其他的测试）。</div><div><strong>测试的频率：</strong></div><div>1.编写新的函数 &nbsp; &nbsp;编译并运行本地的单元测试。</div><div>2.修正bug &nbsp; &nbsp;运行测试来让bug现形；修并再次运行单元测试。</div><div>3.每次成功编译之后 &nbsp;&nbsp;运行本地的单元测试。</div><div>4.每次对版本控制的签入 &nbsp;&nbsp;运行所有的模块或者系统的单元测试。</div><div>5. 持续不断地 &nbsp;&nbsp;应当有一台专门的机器来运行完整的构建和测试。每次都应该从头开始，并且整天自动运行（要么是周期性的，要么是每当有版本控制的签入行为的时候）</div><div><strong>编码和评审以这样的顺序进行：</strong></div><div>1. 编写test case 和/或测试代码。</div><div>2. 评审test case 和/或测试代码。</div><div>3. 经评审修改test case 和/或测试代码。</div><div>4. 编写能通过所有测试的产品代码。</div><div>5. 评审产品代码和测试代码。</div><div>6. 在每次评审后，修改测试代码和产品代码。</div><div><span style="color: #ff0000;">在某些机器上测试失败：</span></div><div><span style="color: #0000ff;">这究竟是为什么呢？这些机器之间有什么区别呢？</span></div><div><span style="color: #0000ff;">比较明显的答案可能是下面这些资源的差异：操作系统版本号、运行库、java运行引擎、数据库驱动等。</span></div><div>统一使用junit 方法的setup 和 tearDown方法。</div></div><img src ="http://www.blogjava.net/javalinjx/aggbug/400624.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/javalinjx/" target="_blank">javalinjx</a> 2013-06-17 09:52 <a href="http://www.blogjava.net/javalinjx/archive/2013/06/17/400624.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>2012年个人总结</title><link>http://www.blogjava.net/javalinjx/archive/2013/01/06/393860.html</link><dc:creator>javalinjx</dc:creator><author>javalinjx</author><pubDate>Sun, 06 Jan 2013 06:16:00 GMT</pubDate><guid>http://www.blogjava.net/javalinjx/archive/2013/01/06/393860.html</guid><wfw:comment>http://www.blogjava.net/javalinjx/comments/393860.html</wfw:comment><comments>http://www.blogjava.net/javalinjx/archive/2013/01/06/393860.html#Feedback</comments><slash:comments>1</slash:comments><wfw:commentRss>http://www.blogjava.net/javalinjx/comments/commentRss/393860.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/javalinjx/services/trackbacks/393860.html</trackback:ping><description><![CDATA[<div><div>&nbsp; &nbsp;本来这个总结要到31号写的，结果太忙了，到了今天才有时间做个总结。</div><div>&nbsp; &nbsp;首先，工作上，从去年的PPM项目一直延续到今年4月份,终于暂时告一个段落了。基本上没有什么收获，架构陈旧，设计原始。。一向对于代码要求相对比较严格的我，实在是重构到快吐了。耦合度太高了，不知道之前写的人是怎么过来的，心里还挺佩服他可以把这个项目做出来。总体上经历了几个项目的开发，实施。从java技术阵营出来，接触到了C，C++，linux等技术，对于</div><div>自己的技术储备又增添了一砖，但都仅限于了解，还达不到熟悉水平。也许是自己就是喜欢java技术吧！</div><div>&nbsp; &nbsp;今年基本上都在外奔波，我和老婆都在外面，话说那会儿她在帝都，我在天津，于是上半年经常两地往返，京津高跌成了我最常用的交通工具:)</div><div>&nbsp; &nbsp;&nbsp;从2011年来公司快两年了，发现自己的开始技术上没有太多的长进，只是自己平时出于对技术的爱好，才能勉强知道相关的新技术的发展，但是还是缺少实践。也许再这样下去，我就搞不了技术了。一直渴望有机会去淘宝一试，但是确由于种种原因未能达成。</div><div>&nbsp; &nbsp;当然今年还有一件重要的事，我们买房了，正式告别了租房的时代，成为了房奴中的一员，哈！这一年，基本没有关注其他的国事，或者经济，当时钓鱼岛事情还是知道的。这一年中，从阅读中得到了不少的收获，看了刘未鹏的〈暗时间〉，看了李笑来的〈把时间当作朋友〉，为何我要提这两本书呢，因为她们带给我了比较多的帮助，虽然有些事情自己也是这么做着，但是却没有坚持，虽然一些事情一直在坚持，却不知道为何要坚持！当然还有技术方面的书籍，这里我就不多说了，可以查看这里http://www.douban.com/people/davylin/ 。&nbsp; &nbsp;</div><div>&nbsp; &nbsp;今年才看了两部电影（和老婆一起看的）：一个是太极，一个是泰囧。话说这个太极真是让人失望，感觉导演故意删减了剧情。</div><div>&nbsp; &nbsp;下面晒一下2012年的榜单：年度电影：泰囧；年度图书：《暗时间》《把时间当作朋友》；年度音乐：我的歌声里，因为爱情；年度技术：clojure（代表人物：dennis)。</div><div>&nbsp; &nbsp;这一年中接触到的新技术有nosql，node.js，clojure，当然还有hadoop，android，ios等等，但都仅限于了解，并没有真正的开始实践，也无从实践，不知道是否有牛人可以指引。</div><div>&nbsp; &nbsp;今年还参与了ROP的前期调研，本想参与开发，但后面却不了了之。参与了anyous的android的客户端开发，结果创新无门，但是现在还在继续中。</div><div>&nbsp; &nbsp;通过新浪微博，认识了很多淘宝系的牛人（这里不一一列举），一步步向他们学习着，在接触到的新技术中，不乏e文资料，深感个人英文水平是软胁。特别是认识了美味系的相关名人，有dennis，sunng，还有胡狼拜月，哈哈，在人脉上似乎收获不少，但是看过书上写的，不是你认识的人多，还是认识你的人多了，才会成为真正的人脉。</div><div>&nbsp; &nbsp;通过今天的学习，对于去年定下的目标基本上都达到了，但是对于java和oracle还是没有达到自己认为应有的高度。（此时，taobao却又在去O运动，这是闹哪门子呢！）</div><div>&nbsp; &nbsp;总之，有所得必有所失，今天失去的就是去老婆相处的时光，希望明天不要出差了:)</div><div>&nbsp; &nbsp;下面说说2013年的展望：</div><div>&nbsp; &nbsp;希望自己可以在所擅长的方向有所突破，可以在一个比较有潜力的团队，使用自己喜欢的语言，对于技术人才高度重视的环境里继续成长。希望可以去两个地方好好休假，体验美好的自然风光。希望交到一些志同道合的朋友，一起开创未来！</div><div>&nbsp; &nbsp;</div><div></div></div><img src ="http://www.blogjava.net/javalinjx/aggbug/393860.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/javalinjx/" target="_blank">javalinjx</a> 2013-01-06 14:16 <a href="http://www.blogjava.net/javalinjx/archive/2013/01/06/393860.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>SQL 21 天自学通学习笔记 5</title><link>http://www.blogjava.net/javalinjx/archive/2012/08/05/384799.html</link><dc:creator>javalinjx</dc:creator><author>javalinjx</author><pubDate>Sun, 05 Aug 2012 03:44:00 GMT</pubDate><guid>http://www.blogjava.net/javalinjx/archive/2012/08/05/384799.html</guid><wfw:comment>http://www.blogjava.net/javalinjx/comments/384799.html</wfw:comment><comments>http://www.blogjava.net/javalinjx/archive/2012/08/05/384799.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/javalinjx/comments/commentRss/384799.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/javalinjx/services/trackbacks/384799.html</trackback:ping><description><![CDATA[<div><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">1. 用户操作：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; &nbsp; 创建：</p><div id="" style="background-color: #ffffff; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word; line-height: 25px; text-align: left; "><div><div style="padding-right: 3px; padding-bottom: 3px; padding-left: 3px; margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica, Tahoma, Arial, sans-serif"><br /></font></div></div><ol start="1" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: #d1d7dc; border-right-color: #d1d7dc; border-bottom-color: #d1d7dc; border-left-color: #d1d7dc; color: #2b91af; "><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">CREATE</span>&nbsp;<span style="color: #ff1493; ">USER</span>&nbsp;<span style="color: #ff1493; ">user</span>&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">IDENTIFIED&nbsp;{<span style="color: #7f0055; ">BY</span>&nbsp;<span style="color: #7f0055; ">password</span>&nbsp;|&nbsp;EXTERNALLY}&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[<span style="color: #7f0055; ">DEFAULT</span>&nbsp;TABLESPACE&nbsp;tablespace]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[<span style="color: #7f0055; ">TEMPORARY</span>&nbsp;TABLESPACE&nbsp;tablespace]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[QUOTA&nbsp;{<span style="color: #7f0055; ">integer</span>&nbsp;[K|M]&nbsp;|&nbsp;UNLIMITED}&nbsp;<span style="color: #7f0055; ">ON</span>&nbsp;tablespace]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[PROFILE&nbsp;profile]&nbsp;&nbsp;</li></ol></div>&nbsp;<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; &nbsp; 修改：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><div id="" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; background-color: #ffffff; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word; line-height: 25px; text-align: left; "><ol start="1" style="font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: #d1d7dc; border-right-color: #d1d7dc; border-bottom-color: #d1d7dc; border-left-color: #d1d7dc; color: #2b91af; "><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">ALTER</span>&nbsp;<span style="color: #ff1493; ">USER</span>&nbsp;<span style="color: #ff1493; ">user</span>&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[IDENTIFIED&nbsp;{<span style="color: #7f0055; ">BY</span>&nbsp;<span style="color: #7f0055; ">password</span>&nbsp;|&nbsp;EXTERNALLY}]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[<span style="color: #7f0055; ">DEFAULT</span>&nbsp;TABLESPACE&nbsp;tablespace]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[<span style="color: #7f0055; ">TEMPORARY</span>&nbsp;TABLESPACE&nbsp;tablespace]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[QUOTA&nbsp;{<span style="color: #7f0055; ">integer</span>&nbsp;[K|M]&nbsp;|&nbsp;UNLIMITED}&nbsp;<span style="color: #7f0055; ">ON</span>&nbsp;tablespace]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[PROFILE&nbsp;profile]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[<span style="color: #7f0055; ">DEFAULT</span>&nbsp;ROLE&nbsp;{&nbsp;role&nbsp;[,&nbsp;role]&nbsp;...&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">|&nbsp;<span style="color: #808080; ">ALL</span>&nbsp;[<span style="color: #7f0055; ">EXCEPT</span>&nbsp;role&nbsp;[,&nbsp;role]&nbsp;...]&nbsp;|&nbsp;NONE}]&nbsp;&nbsp;</li></ol></div>&nbsp;<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; &nbsp; 删除：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><div id="" style="background-color: #ffffff; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word; line-height: 25px; text-align: left; "><ol start="1" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: #d1d7dc; border-right-color: #d1d7dc; border-bottom-color: #d1d7dc; border-left-color: #d1d7dc; color: #2b91af; "><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">DROP</span>&nbsp;<span style="color: #ff1493; ">USER</span>&nbsp;user_name&nbsp;[<span style="color: #7f0055; ">CASCADE</span>]&nbsp;&nbsp;</li></ol></div>&nbsp;<span style="background-color: #ffffff; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; ">&nbsp;</span><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; &nbsp; 授权，撤销权限：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><div id="" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; background-color: #ffffff; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word; line-height: 25px; text-align: left; "><ol start="1" style="font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: #d1d7dc; border-right-color: #d1d7dc; border-bottom-color: #d1d7dc; border-left-color: #d1d7dc; color: #2b91af; "><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">GRANT</span>&nbsp;role&nbsp;<span style="color: #7f0055; ">TO</span>&nbsp;<span style="color: #ff1493; ">user</span>&nbsp;[<span style="color: #7f0055; ">WITH</span>&nbsp;ADMIN&nbsp;<span style="color: #7f0055; ">OPTION</span>]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">REVOKE</span>&nbsp;role&nbsp;<span style="color: #7f0055; ">FROM</span>&nbsp;<span style="color: #ff1493; ">user</span>&nbsp;&nbsp;</li></ol></div>&nbsp;<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; &nbsp; 系统允许 赋于整个系统的权限给用户，角色等：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><div id="" style="background-color: #ffffff; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word; line-height: 25px; text-align: left; "><ol start="1" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: #d1d7dc; border-right-color: #d1d7dc; border-bottom-color: #d1d7dc; border-left-color: #d1d7dc; color: #2b91af; "><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">GRANT</span>&nbsp;system_privilege&nbsp;<span style="color: #7f0055; ">TO</span>&nbsp;{user_name&nbsp;|&nbsp;role&nbsp;|&nbsp;<span style="color: #7f0055; ">PUBLIC</span>}&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[<span style="color: #7f0055; ">WITH</span>&nbsp;ADMIN&nbsp;<span style="color: #7f0055; ">OPTION</span>]&nbsp;&nbsp;</li></ol></div>&nbsp;<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; &nbsp;&nbsp;如果使用了WITH ADMIN OPTION 选项就允许拥有该权限的人将该权限应用给其它</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; &nbsp; 的用户。</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; &nbsp;&nbsp;你可以使用下边的GRANT 语句来对其它用户授权访问你的表</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><div id="" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; background-color: #ffffff; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word; line-height: 25px; text-align: left; "><ol start="1" style="font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: #d1d7dc; border-right-color: #d1d7dc; border-bottom-color: #d1d7dc; border-left-color: #d1d7dc; color: #2b91af; "><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">GRANT</span>&nbsp;{object_priv&nbsp;|&nbsp;<span style="color: #808080; ">ALL</span>&nbsp;[<span style="color: #7f0055; ">PRIVILEGES</span>]}&nbsp;[&nbsp;(<span style="color: #7f0055; ">column</span>&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[,&nbsp;<span style="color: #7f0055; ">column</span>]...)&nbsp;]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[,&nbsp;{object_priv&nbsp;|&nbsp;<span style="color: #808080; ">ALL</span>&nbsp;[<span style="color: #7f0055; ">PRIVILEGES</span>]}&nbsp;[&nbsp;(<span style="color: #7f0055; ">column</span>&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[,&nbsp;<span style="color: #7f0055; ">column</span>]&nbsp;...)&nbsp;]&nbsp;]&nbsp;...&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">ON</span>&nbsp;[<span style="color: #7f0055; ">schema</span>.]object&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">TO</span>&nbsp;{<span style="color: #ff1493; ">user</span>&nbsp;|&nbsp;role&nbsp;|&nbsp;<span style="color: #7f0055; ">PUBLIC</span>}&nbsp;[,&nbsp;{<span style="color: #ff1493; ">user</span>&nbsp;|&nbsp;role&nbsp;|&nbsp;<span style="color: #7f0055; ">PUBLIC</span>}]&nbsp;...&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[<span style="color: #7f0055; ">WITH</span>&nbsp;<span style="color: #7f0055; ">GRANT</span>&nbsp;<span style="color: #7f0055; ">OPTION</span>]&nbsp;&nbsp;</li></ol></div>&nbsp;<p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; &nbsp;&nbsp;如果你想取消对某个对象对于某人的授权你可以使用REVOKE 语句语法如下</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><div id="" style="font-family: Monaco, 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', Consolas, 'Courier New', monospace; background-color: #ffffff; width: 679px; margin-left: 9px; padding-right: 1px; padding-bottom: 1px; padding-left: 1px; word-break: break-all; word-wrap: break-word; line-height: 25px; text-align: left; "><ol start="1" style="font-size: 1em; line-height: 1.4em; margin-left: 0px; padding-top: 2px; padding-bottom: 2px; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; border-top-style: solid; border-right-style: solid; border-bottom-style: solid; border-left-style: solid; border-top-color: #d1d7dc; border-right-color: #d1d7dc; border-bottom-color: #d1d7dc; border-left-color: #d1d7dc; color: #2b91af; "><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">REVOKE</span>&nbsp;{object_priv&nbsp;|&nbsp;<span style="color: #808080; ">ALL</span>&nbsp;[<span style="color: #7f0055; ">PRIVILEGES</span>]}&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[,&nbsp;{object_priv&nbsp;|&nbsp;<span style="color: #808080; ">ALL</span>&nbsp;[<span style="color: #7f0055; ">PRIVILEGES</span>]}&nbsp;]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">ON</span>&nbsp;[<span style="color: #7f0055; ">schema</span>.]object&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; "><span style="color: #7f0055; ">FROM</span>&nbsp;{<span style="color: #ff1493; ">user</span>&nbsp;|&nbsp;role&nbsp;|&nbsp;<span style="color: #7f0055; ">PUBLIC</span>}&nbsp;[,&nbsp;{<span style="color: #ff1493; ">user</span>&nbsp;|&nbsp;role&nbsp;|&nbsp;<span style="color: #7f0055; ">PUBLIC</span>}]&nbsp;&nbsp;</li><li style="margin-left: 38px; padding-right: 0px; font-size: 1em; border-left-width: 1px; border-left-color: #d1d7dc; background-color: #fafafa; line-height: 18px; ">[<span style="color: #7f0055; ">CASCADE</span>&nbsp;CONSTRAINTS]&nbsp;&nbsp;</li></ol></div>&nbsp;&nbsp;</div><img src ="http://www.blogjava.net/javalinjx/aggbug/384799.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/javalinjx/" target="_blank">javalinjx</a> 2012-08-05 11:44 <a href="http://www.blogjava.net/javalinjx/archive/2012/08/05/384799.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>SQL 21 天自学通学习笔记 4</title><link>http://www.blogjava.net/javalinjx/archive/2012/08/05/384796.html</link><dc:creator>javalinjx</dc:creator><author>javalinjx</author><pubDate>Sun, 05 Aug 2012 03:23:00 GMT</pubDate><guid>http://www.blogjava.net/javalinjx/archive/2012/08/05/384796.html</guid><wfw:comment>http://www.blogjava.net/javalinjx/comments/384796.html</wfw:comment><comments>http://www.blogjava.net/javalinjx/archive/2012/08/05/384796.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/javalinjx/comments/commentRss/384796.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/javalinjx/services/trackbacks/384796.html</trackback:ping><description><![CDATA[<div><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">1. insert select 用法：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; "><span style="white-space: pre; ">	</span>insert into tablename1 (col1,col2)</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; "><span style="white-space: pre; ">	</span>select col1,col2 from tablename2 ;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">2. &nbsp;删除表：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; "><span style="white-space: pre; ">	</span>drop table ovner.tablename;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">3. 创建视图：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; "><span style="white-space: pre; ">	</span>CREATE VIEW &lt;view_name&gt; [(column1, column2...)] AS</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; "><span style="white-space: pre; ">	</span>SELECT &lt;table_name column_names&gt;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; "><span style="white-space: pre; ">	</span>FROM &lt;table_name&gt;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">在视图的select 语句中使用约束是必然的，在使用select 语句中可以应用下边两个规则：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">a. 不能使用union操作；</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">b. 不能使用order by 子句但是在视图中使用group by 子句可以有order by 子句相同的功能；</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">还要注意：1. 对于多表视图你不能使用delete 语句；2.除非底层表的所有非空列都已经在视图中</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; "><span style="white-space: pre; ">	</span>出现，否则你不能使用insert语句；</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">4. 索引 &nbsp;index:</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; "><span style="white-space: pre; ">	</span>CREATE INDEX index_name ON table_name(column_name1, [column_name2], ...)</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; "><span style="white-space: pre; ">	</span>CREATE INDEX&nbsp;<span style="white-space: pre; ">	</span>[schema.]index ON { [schema.]table (column [!!under!!ASC|DESC] [, column<span style="white-space: pre; ">	</span>[!!under!!ASC|DESC]]&nbsp;<span style="white-space: pre; ">	</span>...) | CLUSTER [schema.]cluster }</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;&nbsp;<span style="white-space: pre; ">	</span>当表被删除时，所有与表相关的索引也将被删除.</p></div><img src ="http://www.blogjava.net/javalinjx/aggbug/384796.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/javalinjx/" target="_blank">javalinjx</a> 2012-08-05 11:23 <a href="http://www.blogjava.net/javalinjx/archive/2012/08/05/384796.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>SQL 21 天自学通学习笔记 3 </title><link>http://www.blogjava.net/javalinjx/archive/2012/06/17/380971.html</link><dc:creator>javalinjx</dc:creator><author>javalinjx</author><pubDate>Sun, 17 Jun 2012 14:47:00 GMT</pubDate><guid>http://www.blogjava.net/javalinjx/archive/2012/06/17/380971.html</guid><wfw:comment>http://www.blogjava.net/javalinjx/comments/380971.html</wfw:comment><comments>http://www.blogjava.net/javalinjx/archive/2012/06/17/380971.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/javalinjx/comments/commentRss/380971.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/javalinjx/services/trackbacks/380971.html</trackback:ping><description><![CDATA[<div><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">1. STARTING WITH 子句 相当于like (**%);</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">2. order by 子句</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">3. group by 子句</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">4. having 子句</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">SQL&gt; select team,avg(sickleave),avg(annualleave) from orgchart&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; 2 &nbsp;group by team</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; 3 &nbsp;having avg(sickleave)&gt;25 and avg(annualleave)&lt;20;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">TEAM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AVG(SICKLEAVE) AVG(ANNUALLEAVE)</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">--------------- -------------- ----------------</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">RESEARCH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14.5</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">MARKETING &nbsp; &nbsp; &nbsp; 28.33333333333 15.3333333333333</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">SQL&gt; select * from orgchart;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEAM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SALARY SICKLEAVE ANNUALLEAVE</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">--------------- --------------- ------------ --------- -----------</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">ADAMS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RESEARCH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34000.00 &nbsp; &nbsp; &nbsp; &nbsp;34 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">WILKES &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MARKETING &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31000.00 &nbsp; &nbsp; &nbsp; &nbsp;40 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">STOKES &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MARKETING &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36000.00 &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;19</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">MEZA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COLLECTIONS &nbsp; &nbsp; &nbsp; &nbsp; 40000.00 &nbsp; &nbsp; &nbsp; &nbsp;30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">MERRICK &nbsp; &nbsp; &nbsp; &nbsp; RESEARCH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;45000.00 &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">RICHARDSON &nbsp; &nbsp; &nbsp;MARKETING &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 42000.00 &nbsp; &nbsp; &nbsp; &nbsp;25 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">FURY &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COLLECTIONS &nbsp; &nbsp; &nbsp; &nbsp; 35000.00 &nbsp; &nbsp; &nbsp; &nbsp;22 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">PRECOURT &nbsp; &nbsp; &nbsp; &nbsp;PR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;37500.00 &nbsp; &nbsp; &nbsp; &nbsp;24 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">8 rows selected</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">SQL&gt; select team,avg(sickleave),avg(annualleave) from orgchart</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; 2 &nbsp;group by team having count (team)&gt;1;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">TEAM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AVG(SICKLEAVE) AVG(ANNUALLEAVE)</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">--------------- -------------- ----------------</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">COLLECTIONS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 26 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 20.5</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">RESEARCH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 14.5</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">MARKETING &nbsp; &nbsp; &nbsp; 28.33333333333 15.3333333333333</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">SQL&gt; select team,avg(salary)from orgchart</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; 2 &nbsp;group by team having team in ('PR','RESEARCH');</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">TEAM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;AVG(SALARY)</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">--------------- -----------</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">PR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;37500</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">RESEARCH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;39500</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">5. 两者结合使用：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">SQL&gt; select * from orgchart order by name desc;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TEAM &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SALARY SICKLEAVE ANNUALLEAVE</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">--------------- --------------- ------------ --------- -----------</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">WILKES &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MARKETING &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 31000.00 &nbsp; &nbsp; &nbsp; &nbsp;40 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 9</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">STOKES &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MARKETING &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 36000.00 &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;19</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">RICHARDSON &nbsp; &nbsp; &nbsp;MARKETING &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 42000.00 &nbsp; &nbsp; &nbsp; &nbsp;25 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;18</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">PRECOURT &nbsp; &nbsp; &nbsp; &nbsp;PR &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;37500.00 &nbsp; &nbsp; &nbsp; &nbsp;24 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;24</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">MEZA &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COLLECTIONS &nbsp; &nbsp; &nbsp; &nbsp; 40000.00 &nbsp; &nbsp; &nbsp; &nbsp;30 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;27</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">MERRICK &nbsp; &nbsp; &nbsp; &nbsp; RESEARCH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;45000.00 &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;17</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">FURY &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;COLLECTIONS &nbsp; &nbsp; &nbsp; &nbsp; 35000.00 &nbsp; &nbsp; &nbsp; &nbsp;22 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;14</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">ADAMS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; RESEARCH &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;34000.00 &nbsp; &nbsp; &nbsp; &nbsp;34 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">8 rows selected</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">SQL&gt; select payee,sum(amount)total,count(payee)number_written from checks&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; 2 &nbsp;group by payee having sum(amount) &gt; 50;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">PAYEE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TOTAL NUMBER_WRITTEN</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">------------------------------------ ---------- --------------</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">Ma Bell &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;350.32 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">Reading R.R. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 245.34 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">Local Utilities &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;98 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">Joes Stale$ Dent &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;150 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">SQL&gt; select payee,sum(amount) total,count(payee)number_written&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; 2 &nbsp;from checks where amount &gt;= 100 group by payee</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; 3 &nbsp;having sum(amount) &gt; 50;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">PAYEE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; TOTAL NUMBER_WRITTEN</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">------------------------------------ ---------- --------------</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">Ma Bell &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;350.32 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">Reading R.R. &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 245.34 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">Joes Stale$ Dent &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;150 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;where 子句与order by子句常在对单行进行处理时用到；</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;group by 和 having子句常用在对数据进行汇总操作上。</p></div><img src ="http://www.blogjava.net/javalinjx/aggbug/380971.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/javalinjx/" target="_blank">javalinjx</a> 2012-06-17 22:47 <a href="http://www.blogjava.net/javalinjx/archive/2012/06/17/380971.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>SQL 21 天自学通学习笔记 2</title><link>http://www.blogjava.net/javalinjx/archive/2012/06/17/380970.html</link><dc:creator>javalinjx</dc:creator><author>javalinjx</author><pubDate>Sun, 17 Jun 2012 14:46:00 GMT</pubDate><guid>http://www.blogjava.net/javalinjx/archive/2012/06/17/380970.html</guid><wfw:comment>http://www.blogjava.net/javalinjx/comments/380970.html</wfw:comment><comments>http://www.blogjava.net/javalinjx/archive/2012/06/17/380970.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/javalinjx/comments/commentRss/380970.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/javalinjx/services/trackbacks/380970.html</trackback:ping><description><![CDATA[&nbsp;&nbsp;&nbsp;&nbsp; 摘要: 日期、时间函数：&nbsp;select * from project;&nbsp;针对日期型：&nbsp;1. add_months: &nbsp;增加月份&nbsp; &nbsp; select * from task,startdate,enddate,original_end,add_months(enddate,2) from project;&nbsp;&nbsp; &nbsp; se...&nbsp;&nbsp;<a href='http://www.blogjava.net/javalinjx/archive/2012/06/17/380970.html'>阅读全文</a><img src ="http://www.blogjava.net/javalinjx/aggbug/380970.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/javalinjx/" target="_blank">javalinjx</a> 2012-06-17 22:46 <a href="http://www.blogjava.net/javalinjx/archive/2012/06/17/380970.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>SQL 21 天自学通学习笔记 1</title><link>http://www.blogjava.net/javalinjx/archive/2012/06/17/380969.html</link><dc:creator>javalinjx</dc:creator><author>javalinjx</author><pubDate>Sun, 17 Jun 2012 14:44:00 GMT</pubDate><guid>http://www.blogjava.net/javalinjx/archive/2012/06/17/380969.html</guid><wfw:comment>http://www.blogjava.net/javalinjx/comments/380969.html</wfw:comment><comments>http://www.blogjava.net/javalinjx/archive/2012/06/17/380969.html#Feedback</comments><slash:comments>0</slash:comments><wfw:commentRss>http://www.blogjava.net/javalinjx/comments/commentRss/380969.html</wfw:commentRss><trackback:ping>http://www.blogjava.net/javalinjx/services/trackbacks/380969.html</trackback:ping><description><![CDATA[<div><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">中午又看了一下汇总函数：</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">count ,sum,avg,max,min,variance(方差),stddev</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">1. &nbsp;SELECT COUNT( ) FROM TEAMSTATS WHERE HITS/AB .35; &nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">2. &nbsp;SELECT SUM(SINGLES) TOTAL_SINGLES FROM TEAMSTATS; &nbsp;//不能处理 字符型</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">3. &nbsp;SELECT AVG(SO) AVE_STRIKE_OUTS FROM TEAMSTATS;&nbsp;&nbsp;//不能处理 字符型</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">4. &nbsp;SELECT MAX(HITS) FROM TEAMSTATS;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">5. &nbsp;SELECT MIN(AB) FROM TEAMSTATS; &nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">6. &nbsp;SELECT VARIANCE(HITS) FROM TEAMSTATS; &nbsp;&nbsp;//不能处理字符型</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">7. &nbsp;SELECT STDDEV(HITS) FROM TEAMSTATS; &nbsp;//不能处理字符型</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">8. &nbsp;SELECT COUNT AB AVG(AB) MIN(AB) MAX(AB) STDDEV(AB)</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp; &nbsp; &nbsp;VARIANCE(AB) SUM(AB) FROM TEAMSTATS;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;</p><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 0px; padding-left: 0px; font-family: Helvetica, Tahoma, Arial, sans-serif; line-height: 25px; text-align: left; background-color: #ffffff; ">&nbsp;注意：汇总函数不能放在where子句中使用，持续更新。。</p></div><img src ="http://www.blogjava.net/javalinjx/aggbug/380969.html" width = "1" height = "1" /><br><br><div align=right><a style="text-decoration:none;" href="http://www.blogjava.net/javalinjx/" target="_blank">javalinjx</a> 2012-06-17 22:44 <a href="http://www.blogjava.net/javalinjx/archive/2012/06/17/380969.html#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>