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
答案解析:有
微信扫一扫手机做题