问题是什么?我这边一切正常...SQL> select empno, ename, job, sal from scott.emp group by job, empno, ename, sa l; EMPNO ENAME JOB SAL ---------- ---------- --------- ---------- 7698 BLAKE MANAGER 2850 7844 TURNER SALESMAN 1500 7654 MARTIN SALESMAN 1250 7782 CLARK MANAGER 2450 7788 SCOTT ANALYST 3000 7902 FORD ANALYST 3000 7369 SMITH CLERK 800 7499 ALLEN SALESMAN 1600 7876 ADAMS CLERK 1100 7934 MILLER CLERK 1300 7521 WARD SALESMAN 1250 EMPNO ENAME JOB SAL ---------- ---------- --------- ---------- 7839 KING PRESIDENT 5000 7566 JONES MANAGER 2975 7900 JAMES CLERK 950已选择14行。SQL>
7844 TURNER SALESMAN 1500 7654 MARTIN SALESMAN 1250 7499 ALLEN SALESMAN 1600 7521 WARD SALESMAN 1250 7782 CLARK MANAGER 2450 7698 BLAKE MANAGER 2850 7788 SCOTT ANALYST 3000 7902 FORD ANALYST 3000 7369 SMITH CLERK 800 7876 ADAMS CLERK 1100 7934 MILLER CLERK 1300就是按上面的顺序排列。。 我在一个教程里面看到的,可是我自己做的时候就不行。。 是不是少些什么语句?
l; EMPNO ENAME JOB SAL
---------- ---------- --------- ----------
7698 BLAKE MANAGER 2850
7844 TURNER SALESMAN 1500
7654 MARTIN SALESMAN 1250
7782 CLARK MANAGER 2450
7788 SCOTT ANALYST 3000
7902 FORD ANALYST 3000
7369 SMITH CLERK 800
7499 ALLEN SALESMAN 1600
7876 ADAMS CLERK 1100
7934 MILLER CLERK 1300
7521 WARD SALESMAN 1250 EMPNO ENAME JOB SAL
---------- ---------- --------- ----------
7839 KING PRESIDENT 5000
7566 JONES MANAGER 2975
7900 JAMES CLERK 950已选择14行。SQL>
7654 MARTIN SALESMAN 1250
7499 ALLEN SALESMAN 1600
7521 WARD SALESMAN 1250
7782 CLARK MANAGER 2450
7698 BLAKE MANAGER 2850
7788 SCOTT ANALYST 3000
7902 FORD ANALYST 3000
7369 SMITH CLERK 800
7876 ADAMS CLERK 1100
7934 MILLER CLERK 1300就是按上面的顺序排列。。
我在一个教程里面看到的,可是我自己做的时候就不行。。
是不是少些什么语句?