Details
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.
Additional Information
| Special Price | $3.00 |
|---|
Check items to add to the cart or select all
-
DAT/380 Week 2 LAB 2.9 - Select movie ratings with left join
Add to WishlistRegular Price:
Special Price
You have no items in your shopping cart.
