SQL query to get the employee name and their manager name from the same table

You can self-join the table to get the manager’s name from his ID:

SELECT e.employee_name, m.employee_name AS manager_name
FROM   employee e
JOIN   employee m on e.manager_id = m.employee_id

Related Posts:

  1. SQL update from one Table to another based on a ID match
  2. Inserting multiple rows in a single SQL query? [duplicate]
  3. How do I UPDATE from a SELECT in SQL Server?
  4. T-SQL split string
  5. The SQL OVER() clause – when and why is it useful?
  6. Update multiple columns in SQL
  7. SQL Server IF EXISTS THEN 1 ELSE 2
  8. SQL Query with SUM with Group By
  9. How do I perform an IF…THEN in an SQL SELECT?
  10. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  11. How to drop all tables from a database with one SQL query?
  12. SQL Server : Arithmetic overflow error converting expression to data type int
  13. How to calculate percentage with a SQL statement
  14. Query comparing dates in SQL
  15. Best way to do nested case statement logic in SQL Server
  16. What is the meaning of the prefix N in T-SQL statements and when should I use it?
  17. Query error with ambiguous column name in SQL
  18. How to drop all tables from a database with one SQL query?
  19. How to find sum of multiple columns in a table in SQL Server 2005?
  20. How can I delete using INNER JOIN with SQL Server?
  21. Conversion of a varchar data type to a datetime data type resulted in an out-of-range value in SQL query
  22. CREATE TABLE IF NOT EXISTS equivalent in SQL Server
  23. How to group by month from Date field using sql
  24. How can I get column names from a table in SQL Server?
  25. Is there a combination of “LIKE” and “IN” in SQL?
  26. Search text in stored procedure in SQL Server
  27. How to format a numeric column as phone number in SQL
  28. SQL – WHERE (X, Y) IN (A, B)
  29. sql query to return differences between two tables
  30. SQL: IF clause within WHERE clause
  31. How to select the last record of a table in SQL?
  32. SQL- Ignore case while searching for a string
  33. Using Excel VBA to run SQL query
  34. What is tableName.* in SQL
  35. Selecting COUNT(*) with DISTINCT
  36. Case in Select Statement
  37. What is a stored procedure?
  38. What do Clustered and Non-Clustered index actually mean?
  39. Conversion failed when converting date and/or time from character string while inserting datetime
  40. Self Join to get employee manager name
  41. SQL query to select dates between two dates
  42. SQL SELECT WHERE field contains words
  43. Conversion failed when converting date and/or time from character string while inserting datetime
  44. When should I use CROSS APPLY over INNER JOIN?
  45. Insert Data Into Temp Table with Query
  46. error, string or binary data would be truncated when trying to insert
  47. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  48. NOT IN vs NOT EXISTS
  49. SQL SELECT WHERE field contains words
  50. How can I do an UPDATE statement with JOIN in SQL Server?
  51. Must declare the scalar variable
  52. Must declare the scalar variable
  53. Rename column SQL Server 2008
  54. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  55. Efficiently convert rows to columns in sql server
  56. How to delete duplicate rows in SQL Server?
  57. Nested select statement in SQL Server
  58. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  59. SQL SELECT WHERE field contains words
  60. SQL Query with NOT LIKE IN
  61. How do I escape a single quote in SQL Server?
  62. T-SQL split string based on delimiter
  63. ORA-01843 not a valid month- Comparing Dates
  64. Drop a temporary table if it exists
  65. How do I escape a single quote in SQL Server?
  66. How Stuff and ‘For Xml Path’ work in SQL Server?
  67. Data source name not found, and no default driver specified
  68. IDENTITY_INSERT is set to OFF – How to turn it ON?
  69. An attempt was made to access a socket in a way forbidden by its access permissions
  70. Each GROUP BY expression must contain at least one column that is not an outer reference
  71. Optimistic vs. Pessimistic locking
  72. Column name or number of supplied values does not match table definition
  73. Inserting data into a temporary table
  74. Can a foreign key be NULL and/or duplicate?
  75. Why does NULL = NULL evaluate to false in SQL server
  76. When to use SELECT … FOR UPDATE?
  77. CREATE VIEW must be the only statement in the batch
  78. SQL Server FOR EACH Loop
  79. Difference between JOIN and INNER JOIN
  80. The target principal name is incorrect. Cannot generate SSPI context
  81. The EXECUTE permission was denied on the object ‘xxxxxxx’, database ‘zzzzzzz’, schema ‘dbo’
  82. BCP error “Unable to open BCP host data-file”
  83. How can I clone an SQL Server database on the same server in SQL Server 2008 Express?
  84. The multi-part identifier could not be bound
  85. “CASE” statement within “WHERE” clause in SQL Server 2008
  86. Get day of week in SQL Server 2005/2008
  87. How to join two tables by multiple columns in SQL?
  88. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  89. incorrect syntax error CREATE VIEW must be the only statement in the batch
  90. SQL Server : error converting data type varchar to numeric
  91. Conversion failed when converting from a character string to uniqueidentifier – Two GUIDs
  92. Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint
  93. Keeping it simple and how to do multiple CTE in a query
  94. Why use a READ UNCOMMITTED isolation level?
  95. Find all tables containing column with specified name – MS SQL Server
  96. DateTime2 vs DateTime in SQL Server
  97. Difference between numeric, float and decimal in SQL Server
  98. SQL Server Insert if not exists
  99. How can I import an Excel file into SQL Server?
  100. SQL Server: Invalid Column Name

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)