SQL Subquery Exercises: Display the name , salary, department id, job id for those employees who works in the same designation as the employee works whose id is 169
SQL SUBQUERY : Exercise-2 with Solution
Write a query to display the name ( first name and last name ), salary, department id, job id for those employees who works in the same designation as the employee works whose id is 169.
Sample table: employees
Sample Solution :
SELECT first_name, last_name, salary, department_id, job_id FROM employees WHERE job_id = ( SELECT job_id FROM employees WHERE employee_id=169 );
first_name last_name salary department_id job_id Peter Tucker 10000.00 80 SA_REP David Bernstein 9500.00 80 SA_REP Peter Hall 9000.00 80 SA_REP Christopher Olsen 8000.00 80 SA_REP Nanette Cambrault 7500.00 80 SA_REP Oliver Tuvault 7000.00 80 SA_REP Janette King 10000.00 80 SA_REP Patrick Sully 9500.00 80 SA_REP Allan McEwen 9000.00 80 SA_REP Lindsey Smith 8000.00 80 SA_REP Louise Doran 7500.00 80 SA_REP Sarath Sewall 7000.00 80 SA_REP Clara Vishney 10500.00 80 SA_REP Danielle Greene 9500.00 80 SA_REP Mattea Marvins 7200.00 80 SA_REP David Lee 6800.00 80 SA_REP Sundar Ande 6400.00 80 SA_REP Amit Banda 6200.00 80 SA_REP Lisa Ozer 11500.00 80 SA_REP Harrison Bloom 10000.00 80 SA_REP Tayler Fox 9600.00 80 SA_REP William Smith 7400.00 80 SA_REP Elizabeth Bates 7300.00 80 SA_REP Sundita Kumar 6100.00 80 SA_REP Ellen Abel 11000.00 80 SA_REP Alyssa Hutton 8800.00 80 SA_REP Jonathon Taylor 8600.00 80 SA_REP Jack Livingston 8400.00 80 SA_REP Kimberely Grant 7000.00 0 SA_REP Charles Johnson 6200.00 80 SA_REP
Contribute your code and comments through Disqus.
Previous: Write a query to display the name ( first name and last name ) for those employees who gets more salary than the employee whose id is 163.
Next: Write a query to display the name ( first name and last name ), salary, department id for those employees who earn such amount of salary which is the smallest salary of any of the departments.
What is the difficulty level of this exercise?