对Oracle中分组函数的一点点理解(外国英语资料).docVIP

对Oracle中分组函数的一点点理解 Group by is sometimes used to use the following grouping functions Count (AVG) (max) (); / / general application in the digital. Min (); sum () If the grouping function is used in the program, there are two things that can be used: 1. Group by is present in the program and the grouping conditions are formulated so that the grouping conditions can be queried together 2. If you do not use group by, you can only use the grouping function alone So: select deptno, count from EMP (empno); / / error: not a single group function Change: select, deptno, count (empno), from, EMP, group, by, deptno; Select deptno, ename, count (empno) from EMP group by deptno; / / error: not a group by expression The summary is that the group, by, and group functions give the concept of the field group, and in that case the group by is modified Fields and fields that are modified by group functions are group fields, and the preceding is not a group field, and of course there is an error Where, group, by, having, order, by, -----wgho --- I walk Required to show an average wage greater than 2000 of the department number and average wage. Select, deptno, AVG (SAL) From EMP Where AVG (SAL) 2000 Min (); sum () If the grouping function is used in the program, there are two things that can be used: 1. Group by is present in the program and the grouping conditions are formulated so that the grouping conditions can be queried together 2. If you do not use group by, you can only use the grouping function alone So: select deptno, count from EMP (empno); / / error: not a single group function Change: select, deptno, count (empno), from, EMP, group, by, deptno; Select deptno, ename, count (empno) from EMP group by deptno; / / error: not a group by expression The summary is that the group, by, and group functions give the concept of the field group, and in that case the group by is modified Fields and fields that are modified by group functions are group fields, and the preceding is not