單項選擇題

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.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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