SESSION NAME: Sub Queries.
QUESTION NAME: Sub Query - 6.
TABLE DESCRIPTION:
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);
0 Comments