Select the SQL statement which will list the employee(empno) and the project numbers(projno) from the EMPACT table that has an employee(empno) whose salary(salary) is in the top three salaries for all employees from the EMP table.

Question

Accepted Answer

A. SELECT empno, projno

Answer

B. SELECT empno, projno

Answer

C. SELECT ep.empno, projno

Answer

D. SELECT ep.empno, projno

Select the SQL statement which will list the employee(empno) and the project numbers(projno) from the EMPACT table that has an employee(empno) whose salary(salary) is in the top three salaries for…

Question

Options

How the community answered

Explanation

Topics

Community Discussion