DAT/380 Week 2 LAB 2.10 – Select employees and managers with inner join

$ 5

DAT/380 Week 2 LAB 2.10 – Select employees and managers with inner join

The Employee table has the following columns:
ID – integer, primary key
FirstName – variable-length string
LastName – variable-length string
ManagerID – integer
Write a SELECT statement to show a list of all employees’ first names and their managers’ first names. List only employees that have a manager. Order the results by Employee first name. Use aliases to give the result columns distinctly different names, like “Employee” and “Manager”.

Hint: Join the Employee table to itself using INNER JOIN.

997 in stock

SKU: DAT380WK2L2P10 Category:

Description

DAT/380 Week 2 LAB 2.10 – Select employees and managers with inner join

The Employee table has the following columns:
ID – integer, primary key
FirstName – variable-length string
LastName – variable-length string
ManagerID – integer
Write a SELECT statement to show a list of all employees’ first names and their managers’ first names. List only employees that have a manager. Order the results by Employee first name. Use aliases to give the result columns distinctly different names, like “Employee” and “Manager”.

Hint: Join the Employee table to itself using INNER JOIN.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.