You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

9 lines
317 B

/*Write a query to display the employee name ( first name and last name ), employee id and salary of all employees who report
to Payam.*/
SELECT first_name, last_name, employee_id, salary
FROM employees
WHERE manager_id =
(SELECT employee_id
FROM employees
WHERE first_name = "Payam"