Pro Oracle SQL Chapter 7
caohong286
这个作者很懒,什么都没留下…
展开
-
《Pro Oracle SQL》Chapter7--7.9GROUPING SETS and ROLLUP()
7.9 GROUPING SETS and ROLLUP() (page 214) There is yet another method that may be used to obtain the results seen in the previous two examples. The GROUPING SETS() extension to GROUP B...2011-12-18 14:08:03 · 95 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter7--7.10GROUP BY Restrictions
7.10 GROUP BY的限制 (page 217) Your study of GROUP BY would be incomplete without considering what it cannot do. The list of restrictions placed on GROUP BY is not very long. The restr...2012-01-01 17:01:44 · 154 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter7 Advanced Grouping -- 7.1Basic GROUP BY Usage
Chapter 7 Advanced Grouping 第七章 高级分组 Jared Still (page 213) The GROUP BY clause is a venerable member of the SQL statement family. After learning basic SELECT statements, it is one o...2011-11-09 23:31:52 · 124 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter7 Advanced Grouping -- 7.2HAVING Clause
7.2 HAVING Clause HAVING 子句 (page 195) Results generated by GROUP BY may be restricted by the criteria found in the HAVING clause. The HAVING clause is quite versatile, resembling the WH...2011-11-15 23:23:25 · 121 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter7 -- 7.3--7.4CUBE Extension to GROUP BY
7.3“New” GROUP BY Functionality “新”GROUP BY 功能 (page 197) At times, it’s necessary to write SQL that appears as unruly as the convoluted example in Listing 7-5 so that the desir...2011-11-17 22:59:18 · 148 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter7 Advanced Grouping -- 7.5Putting CUBE To Work
7.5 Putting CUBE to work CUBE实战 (page 201) When teaching us a new word in fourth grade English class, Mrs. Draper would say, “Now use it in a sentence.” Much like that, you now...2011-11-19 09:31:35 · 116 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter7 --7.6Eliminate NULLs with the GROUPING() Function
7.6 Eliminate NULLs with the GROUPING() Function 用GROUPING()函数消除NULL值 (page 207) There seems to be a problem with the output from the new query seen in Listing 7-12. While the numbers ma...2011-11-23 23:13:10 · 73 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter7 -- 7.7Extending Reports with GROUPING()
7.7Extending Reports with GROUPING() 用GROUPING()函数扩展报告 (page209) Another use of GROUPING() is in the HAVING clause, where it can be used to control which aggregation levels appear in the ou...2011-11-27 00:15:26 · 78 阅读 · 0 评论 -
《Pro Oracle SQL》Chapter7 -- 7.8Extending Reports With GROUPING_ID()
7.8 Extending Reports With GROUPING_ID() 使用GROUPING_ID()扩展报告 (page210) The GROUPING_ID()function is relatively new compared to the GROUPING() function, having beenintroduced in Oracle ...2011-12-10 22:20:07 · 124 阅读 · 0 评论