文件名称:上海部分公司面试题目和Java技巧
文件大小:7.66MB
文件格式:ZIP
更新时间:2011-10-21 12:32:12
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