17.grouping组函数

grouping组函数
Select owner,Count(*) From dba_objects Group By owner --用owner做分组的条件
--ROLLUP的使用
--分组并求合计 
Select owner,Count(*) From dba_objects Group By owner Union Select Null,Count(*) From dba_objects  --使用union查询合计
Select owner,Count(*) From dba_objects Group By rollup(owner)                                      --使用rollup查询合计
--多字段分组
Select owner,status,Count(*) From dba_objects Group By owner,status                                --对字段分组
Select owner,status,Count(*) From dba_objects Group By rollup(owner,status)                        --多字段分组后，对每组合计并最后总计
Select owner,status,Count(*) From dba_objects Group By owner,status 
Union Select owner,Null,Count(*) From dba_objects Group By owner,Null 
Union Select Null,Null,Count(*) From dba_objects                                                   --使用union进行多字段分组求合计和总计

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15810196/viewspace-1079768/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15810196/viewspace-1079768/