Order BY Clause Conflict with Distinct

Transact-SQL
1

Order BY Clause conflict with distinct

2

Make sure the column you want to ORDER BY is in the SELECT list (when you use DISTINCT)