单项选择题
下面哪条语句可以取出薪水最高的前三个人:()
A.SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY );
B.SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY ) WHERE ROWNUM<=3;
C.SELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY DESC) WHERE ROWNUM<=3;
D.SELECT * FROM EMPLOYEES WHERE ROWNUM<=3 ORDER BY SALARY DESC;
点击查看答案&解析
