试题详情
单项选择题下面哪条语句可以取出薪水最高的前三个人:()

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;

  • C
  • 关注下方微信公众号,在线模考后查看

热门试题