2016_sql Learning (1)

Select Deptno, Job, sum (SAL) from the EMP Group by rollup (DEPTNO, job);

Break on Deptno Skip 2;

Set PageSize 30;

Title Col ' Col sql.pno

Col Deptno Heading Department number

Col Job heading Jobs

Col sum (SAL) heading payroll

Break on Deptno Skip 1

Save the above content in E:/oracle/salary.sql

Get E:/oracle/salary.sql

@e:/oracle/salary.sql

Select Deptno, Job, sum (SAL) from the EMP Group by rollup (DEPTNO, job);

Descartes Set

Equivalent connection

No equivalent connection

Select E.ename, E.sal, s.grade from EMP E, Salgrade s where e.sal between S.losal and S.hisal;

External connection

Self-connect

2016_sql Learning (1)