sql*plus中可以用compute命令 SQL> BREAK ON DNAME SKIP 1 SQL> COMPUTE AVG LABEL 'Dept Average' - > MAX LABEL 'Dept Maximum' - > OF SAL ON DNAME SQL> SELECT DNAME, ENAME, SAL 2 FROM DEPT, EMP 3 WHERE DEPT.DEPTNO = EMP.DEPTNO 4 AND DNAME IN ('ACCOUNTING', 'SALES') 5 ORDER BY DNAME; The following output results: DNAME ENAME SAL -------------- ---------- ---------- ACCOUNTING CLARK 2450 KING 5000 MILLER 1300 ************** ---------- Dept Average 2916.66667 Dept Maximum 5000SALES ALLEN 1600 BLAKE 2850 MARTIN 1250 JAMES 950 TURNER 1500 WARD 1250 ************** ---------- Dept Average 1566.66667 Dept Maximum 28509 rows selected.
SQL> BREAK ON DNAME SKIP 1
SQL> COMPUTE AVG LABEL 'Dept Average' -
> MAX LABEL 'Dept Maximum' -
> OF SAL ON DNAME
SQL> SELECT DNAME, ENAME, SAL
2 FROM DEPT, EMP
3 WHERE DEPT.DEPTNO = EMP.DEPTNO
4 AND DNAME IN ('ACCOUNTING', 'SALES')
5 ORDER BY DNAME;
The following output results: DNAME ENAME SAL
-------------- ---------- ----------
ACCOUNTING CLARK 2450
KING 5000
MILLER 1300
************** ----------
Dept Average 2916.66667
Dept Maximum 5000SALES ALLEN 1600
BLAKE 2850
MARTIN 1250
JAMES 950
TURNER 1500
WARD 1250
************** ----------
Dept Average 1566.66667
Dept Maximum 28509 rows selected.