單項選擇題

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;

你可能感興趣的試題

單項選擇題

Which constraint can be defines only at the column level?（）

A.UNIQUE
B.NOT NULL
C.CHECK
D.PRIMARY KEY
E.FOREIGN KEY

單項選擇題

In which scenario would TOP N analysis be the best solution?（）

A. You want to identify the most senior employee in the company.
B. You want to find the manager supervising the largest number of employees.
C. You want to identify the person who makes the highest salary for all employees.
D. You want to rank the top three sales representatives who have sold the maximum number of products.

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区 狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

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?（）

你可能感興趣的試題

Which constraint can be defines only at the column level?（）

In which scenario would TOP N analysis be the best solution?（）

97免费在线观看视频,亚洲综合自拍网,黄色毛片免费观看,热久久综合网,免费看日产一区二区三区狠狠操av,久久久涩涩涩,在线精品免费视频,人人插天天干,久久91精品国产91久久

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?（）