搜索

考试

登录电脑网页、小程序享受畅享刷题等更多功能

The EMP table has these columns: ENAME VARCHAR2(35...

CMS专题

单选题

The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE 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?（）

发布日期：2020-04-10

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;

标签： emp table columns ename varchar2

热门试题

热门资讯

暂无相关推荐~

分享给好友

分享到朋友圈

使用浏览器的分享功能，把这篇文章分享出去

确定