ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

Error Message:
Msg 145, Level 15, State 1, Line 1
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

Severity level:
15.

Description:
This error message appears when you try to execute a SELECT DISTINCT Statement that should be sorted by a column, which does not appear in the SELECT list.

Consequences:
The SQL statement can be parsed, but cannot be executed and execution is stopped.

Resolution:
Error of the severity level 15 are generated by the user and can be fixed by the SQL Server user.

Versions:
All versions of SQL Server.

Example(s):
SELECT DISTINCT CustomerID
  FROM Northwind.dbo.Orders
 ORDER BY OrderID

Remarks:
The above example tries to sort by the column OrderID. Because the keyword DISTINCT is also specified, either the column OrderID must appear in the SELECT list or the resultset must be sorted by CustomerID.




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |