SESSION NAME: Sub Queries.

QUESTION NAME: Sub Query - 6.


TABLE DESCRIPTION:

Write a query to display all the information of an
employee whose salary and reporting manager_id is 3000 and 121 respectively.

Table name = sub_employees
Use Sub Queries

CODE:

SELECT * FROM sub_employees WHERE (salary,manager_id) = (SELECT 3000,121);