Oracle数据库高级实战教程中科院专用Lescn5精华资料集.pptVIP

;;;;HAVING子句的回忆;;;ROLLUP操作的例子;;FROMemployees

GROUPBYROLLUP(department_id,(job_id,manager_id));

FROMemployees

FROM table

FROM table

GROUPING函数：例子

FROM table

SELECTdepartment_id,job_id,

COUNT(employee_id)

HiddenSlide

GROUPBYdepartment_id,job_id;

CUBE分组产生一种包括ROLLUP行和交叉表行的成果集

GROUPING(job_id)GRP_JOB

SELECTdepartment_idDEPTID,job_idJOB,

在本课中,您应该已经学会怎样：

为了指定连接分组集合，用逗号分开多重分组集合，ROLLUP，和CUBE操作，方便Oracle服务器将它们组合在一种单个的GROUPBY子句中

GROUPINGSETS:例子;FROMemployees

FROMemployees

FROM table

WHEREdepartment_id60

COUNT(employee_id)

SELECT [column,]