Manual Oracle Sql*Plus

Sintaxis

SELECT [column,] group_function(column). . .

FROM table

[WHERE condition]

[GROUP BY group_by_expression]

[ORDER BY column];

Ejemplo:

SELECT

   deptno, job, SUM(sal),COUNT(empno)

FROM

   scott.emp

GROUP BY

   deptno, job;

Comments