Retrieve the current salary of an employee
Which SQL query retrieves the current salary of an employee with emp_no = 20005 ?

Question

Retrieve the current salary of an employee 
 Which SQL query retrieves the current salary of an employee with  emp_no = 20005 ?

Accepted Answer

SELECT salary FROM salaries WHERE emp_no = 20005 AND to_date = '9999-01-01';

Answer

SELECT salary FROM employees WHERE emp_no = 20005;

Answer

SELECT salary FROM salaries WHERE emp_no = 20005;

Answer

SELECT salary FROM dept_emp WHERE emp_no = 20005;

Crowdly