單項(xiàng)選擇題

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;

你可能感興趣的試題

單項(xiàng)選擇題

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

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

單項(xiàng)選擇題

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.

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

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