在子查询中禁止使用order by
经典查询:
1.
select job,min(sal),max(sal) from emp group by job
having job='CLERK'
2. select ename,sal,job from emp where job <>'CLERK';
3. select ename,sal,job from emp where sal<all(select avg(sal) from emp group by job);
4.<any(小于最大的);>any(大于最小的);=any(相当于in)
经典查询:
1.
select job,min(sal),max(sal) from emp group by job
having job='CLERK'
2. select ename,sal,job from emp where job <>'CLERK';
3. select ename,sal,job from emp where sal<all(select avg(sal) from emp group by job);
4.<any(小于最大的);>any(大于最小的);=any(相当于in)