试题详情
单项选择题 The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE 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

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

热门试题