单选题

下面哪条语句可以取出薪水最高的前三个人:()

ASELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY );

BSELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY ) WHERE ROWNUM<=3;

CSELECT * FROM (SELECT * FROM EMPLOYEES ORDER BY SALARY DESC) WHERE ROWNUM<=3;

DSELECT * FROM EMPLOYEES WHERE ROWNUM<=3 ORDER BY SALARY DESC;

正确答案

来源:www.examk.com

答案解析