系统环境:windows7 32bit 终极版
软件:oracle 10g 10.2
oracle 10g 命令行输入select avg(sal),max(sal),deptno,job from emp group by deptno,job;
出现如下派讯
AVG(SAL) MAX(SAL) DEPTNO JOB
--------- ---------- ---------- --------------
950 1100 20 CLERK
1400 1600 30 SALESMAN
2975 2975 20 MANAGER
950 950 30 CLERK
5000 5000 10 PRESIDENT
2850 2850 30 MANAGER
1300 1300 10 CLERK
2450 2450 10 MANAGER
3000 3000 20 ANALYST
在DEPTNO 那里是乱排序的,没有从大到小或者从小到大
我看视频的时候,他们的他们是如下所示,请问如何做到这种效果,回答得好给高分。谢谢
他们的命令也是 select avg(sal),max(sal),deptno,job from emp group by deptno,job;
为什么,求解中~~
AVG(SAL) MAX(SAL) DEPTNO JOB
--------- ---------- ---------- --------------
1300 1300 10 CLERK
2450 2450 10 MANAGER
5000 5000 10 PRESIDENT
2975 2975 20 MANAGER
950 1100 20 CLERK
3000 3000 20 ANALYST
950 950 30 CLERK
1400 1600 30 SALESMAN
2850 2850 30 MANAGER
软件:oracle 10g 10.2
oracle 10g 命令行输入select avg(sal),max(sal),deptno,job from emp group by deptno,job;
出现如下派讯
AVG(SAL) MAX(SAL) DEPTNO JOB
--------- ---------- ---------- --------------
950 1100 20 CLERK
1400 1600 30 SALESMAN
2975 2975 20 MANAGER
950 950 30 CLERK
5000 5000 10 PRESIDENT
2850 2850 30 MANAGER
1300 1300 10 CLERK
2450 2450 10 MANAGER
3000 3000 20 ANALYST
在DEPTNO 那里是乱排序的,没有从大到小或者从小到大
我看视频的时候,他们的他们是如下所示,请问如何做到这种效果,回答得好给高分。谢谢
他们的命令也是 select avg(sal),max(sal),deptno,job from emp group by deptno,job;
为什么,求解中~~
AVG(SAL) MAX(SAL) DEPTNO JOB
--------- ---------- ---------- --------------
1300 1300 10 CLERK
2450 2450 10 MANAGER
5000 5000 10 PRESIDENT
2975 2975 20 MANAGER
950 1100 20 CLERK
3000 3000 20 ANALYST
950 950 30 CLERK
1400 1600 30 SALESMAN
2850 2850 30 MANAGER
select avg(sal),max(sal),deptno,job from emp group by deptno,job order by deptno;即可