Java技巧和上海部分公司的面试题目

1：找出公司里收入最高的前三名员工： SQL> select rownum, last_name, salary 2 from (select last_name, salary 3 from s_emp 4 order by salary desc) 5 where rownum<=3; ROWNUM LAST_NAME SALARY ---------- ------------------------- ---------- 1 Velasquez 4750 2 Ropeburn 2945 3 Nguyen 2897.5 注意：请大家分析一下一下语句为什么不对： SQL> select rownum, last_name, salary 2 from s_emp 3 where rownum<=3 4 order by salary desc; ROWNUM LAST_NAME SALARY ---------- ------------------------- ---------- 1 Velasquez 4750 3 Nagayama 2660 2 Ngao 2000