The EMP table has these columns: <img src="/Image1/ef/ef852bda00c7521fd3ca588c3591fb7f.jpg" /> 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?（）<br>A:SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE > 5;<br>B:SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE > 5;<br>C:SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)/365 > 5;<br>D:SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)* 365 > 5;

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;

出自：Oracle认证

提示：
同一【IP】的非会员用户每天可免费获取10次答案

收藏本站【zk.995w.com】，下次访问不迷路

本站试题总数:【10245188】个 (题库试题定时更新)