單項選擇題

下面哪條語句可以取出薪水最高的前三個人:()

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;

微信掃碼免費搜題