Retrieve employee birth dates
Which SQL query retrieves the birth date of the employee with emp_no = 10500 ?

Question

Retrieve employee birth dates 
 Which SQL query retrieves the birth date of the employee with  emp_no = 10500 ?

Accepted Answer

SELECT birth_date FROM employees WHERE emp_no = 10500;

Answer

SELECT birth_date FROM employees WHERE first_name = 'John';

Answer

SELECT birth_date FROM salaries WHERE emp_no = 10500;

Answer

SELECT emp_no FROM employees WHERE birth_date = '1990-05-10';

Crowdly