试题详情
单项选择题 The EMP table has these columns: Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）

A、SELECT ENAME   FROM EMP   WHERE SYSDATE-HIRE_DATE > 5;

B、SELECT ENAME   FROM EMP   WHERE HIRE_DATE-SYSDATE > 5;

C、SELECT ENAME   FROM EMP   WHERE (SYSDATE-HIRE_DATE)/365 > 5;

D、SELECT ENAME   FROM EMP   WHERE (SYSDATE-HIRE_DATE)* 365 > 5;

  • C

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

热门试题