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
SQL
9 lines
317 B
SQL
/*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"
|
|
); |