首页计算机考试Oracle认证
(单选题)

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? ()

ASELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;

BSELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;

CSELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;

DSELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;

正确答案

来源:www.examk.com

答案解析

快考试在线搜题