SQL Print the name of all Employees together with the name of their supervisor

by

Try the below

SELECT  t1.EmployeeName AS Manager, t2.EmployeeID as EmployeeName
FROM  Employee t1 
LEFT  JOIN Employee t2 ON  t1.ManagerID=t2.EmployeeID

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. sql query to modify the selected value from database [closed]
  3. Calculate Average of the largest values in multiple columns
  4. Storing JSON in database vs. having a new column for each key
  5. SQL: Repeat a result row multiple times, and number the rows
  6. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  7. Why do results from a SQL query not come back in the order I expect?
  8. When to use SELECT … FOR UPDATE?
  9. Best practices for SQL varchar column length [closed]
  10. How to transpose rows to columns with large amount of the data in BigQuery/SQL?
  11. how to cast the hexadecimal to varchar(datetime)?
  12. Equivalent of MySQL ON DUPLICATE KEY UPDATE in Sql Server
  13. Why in SQL NULL can’t match with NULL?
  14. Convert SQL Server query to MySQL [duplicate]
  15. comparison of truncate vs delete in mysql/sqlserver [duplicate]
  16. Using column alias in WHERE clause of MySQL query produces an error
  17. Cannot delete or update a parent row: a foreign key constraint fails
  18. Using an Alias in SQL Calculations
  19. How do I select an entire row which has the largest ID in the table?
  20. MySQL/MariaDB – order by inside subquery
  21. Can MySQL replace multiple characters?
  22. Using ORDER BY and GROUP BY together
  23. MySQL Pivot Table Column Data as Rows
  24. updating columns with a sequence number mysql
  25. MySQL, Concatenate two columns
  26. Select a column with a keyword name
  27. ERROR 1148: The used command is not allowed with this MySQL version
  28. Use Composite Primary Key as Foreign Key
  29. What happens when I exhaust a bigint generated key? How to handle it?
  30. is there a length limit to group_concat or another reason why it would not work on a text field

Leave a Comment