多做题,通过考试没问题!

Oracle认证考试

题库首页>其他计算机考试>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?()

  • 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;
查看答案

微信扫一扫手机做题