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

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题