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进行多字段分组求合计和总计
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/