17,086
社区成员
发帖
与我相关
我的任务
分享
select * from (select salary,rownum rn from (select * from emp order BY salary desc) ) where rn<=3;
select * from emp,(select job_id,avg(min_salary)from emp group by empno)
where salary > (select avg(salary) from emp);