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. What do Clustered and Non-Clustered index actually mean?
  36. Conversion failed when converting date and/or time from character string while inserting datetime
  37. SQL query to select dates between two dates
  38. SQL SELECT WHERE field contains words
  39. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  40. NOT IN vs NOT EXISTS
  41. SQL SELECT WHERE field contains words
  42. Efficiently convert rows to columns in sql server
  43. How to delete duplicate rows in SQL Server?
  44. Nested select statement in SQL Server
  45. How do I escape a single quote in SQL Server?
  46. T-SQL split string based on delimiter
  47. Column name or number of supplied values does not match table definition
  48. Inserting data into a temporary table
  49. CREATE VIEW must be the only statement in the batch
  50. SQL Server FOR EACH Loop
  51. Difference between JOIN and INNER JOIN
  52. The target principal name is incorrect. Cannot generate SSPI context
  53. The EXECUTE permission was denied on the object ‘xxxxxxx’, database ‘zzzzzzz’, schema ‘dbo’
  54. BCP error “Unable to open BCP host data-file”
  55. “CASE” statement within “WHERE” clause in SQL Server 2008
  56. What is the difference between Scope_Identity(), Identity(), @@Identity, and Ident_Current()?
  57. Conversion failed when converting from a character string to uniqueidentifier – Two GUIDs
  58. Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint
  59. Keeping it simple and how to do multiple CTE in a query
  60. DateTime2 vs DateTime in SQL Server
  61. Difference between numeric, float and decimal in SQL Server
  62. SQL Server Insert if not exists
  63. SQL Server: Invalid Column Name
  64. sql server invalid object name – but tables are listed in SSMS tables list
  65. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  66. What is the equivalent of ‘describe table’ in SQL Server?
  67. How do I query for all dates greater than a certain date in SQL Server?
  68. String or binary data would be truncated. The statement has been terminated
  69. Add a column with a default value to an existing table in SQL Server
  70. Error converting data type varchar to float
  71. How to concatenate text from multiple rows into a single text string in SQL Server
  72. Count(*) vs Count(1) – SQL Server
  73. ClassNotFoundException – com.microsoft.jdbc.sqlserver.SQLServerDriver
  74. The SELECT permission was denied on the object ‘Users’, database ‘XXX’, schema ‘dbo’
  75. How do you open an SDF file (SQL Server Compact Edition)?
  76. Using RegEx in SQL Server
  77. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  78. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  79. Trouble Connecting to sql server Login failed. “The login is from an untrusted domain and cannot be used with Windows authentication”
  80. Bulk load data conversion error (truncation)
  81. Difference between database and schema
  82. ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.
  83. SQL: Two select statements in one query
  84. SQL Server Linked Server Example Query
  85. How do I format a number with commas in T-SQL?
  86. SQL datetime compare
  87. SQL Server dynamic PIVOT query?
  88. Incorrect syntax near ”
  89. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  90. To add server using sp_addlinkedserver
  91. Get everything after and before certain character in SQL Server
  92. How to connect to a local database in SQL Server Management Studio?
  93. DATEDIFF function in Oracle
  94. What are named pipes?
  95. Comma separated results in SQL
  96. INSERT VALUES WHERE NOT EXISTS
  97. How to implement LIMIT with SQL Server? [duplicate]
  98. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  99. Help me SELECT thumbnail from SQL and use
  100. Database SQL query error

Leave a Comment