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认证

完成拼图验证

按住下方滑块,将拼图拖到缺口处后松开。

拼图背景,将小拼图拖到缺口处
向右拖动滑块