Find the job title of an employee
Which SQL query retrieves the title of an employee with emp_no = 30001 ?

Question

Find the job title of an employee 
 Which SQL query retrieves the title of an employee with  emp_no = 30001 ?

Answer

SELECT title FROM titles WHERE emp_no = 30001;

Answer

SELECT title FROM titles WHERE emp_no = 30001 AND to_date = '9999-01-01';

Answer

SELECT title FROM salaries WHERE emp_no = 30001;

Answer

SELECT title FROM employees WHERE emp_no = 30001;

Crowdly