Question

oracle emp表 显示所有员工，按名字降序排列，若相同，则按工资升序排序 ？

Answer 1

select * from emp order by name desc,salary asc;

Answer 2

select * from emp order by name desc,salary;

Answer 3

* from emp order by sal desc) a1 where rownum<=3 ;
呵呵，在Oracle上试过了，运行出了结果

Answer 4

select * from emp order by name , values desc