可学答题网 > 问答 > 1Z0-007题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

The EMP table has these columns: Man


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
参考答案
参考解析:
分类:1Z0-007题库