How to use ORDER BY clause in select statement with distinct?

Question

The problem is that the columns used in the ORDER BY aren't specified in the DISTINCT . To do this, you need to use an aggregate function to sort on, .sql - Using distinct on a column and doing order by on another .SQL Select Distinct Values, but order by a different valueSELECT DISTINCT and ORDER BY number of same valuesSQL Server Select Distinct and Order By with CASE - Stack OverflowДругие результаты с сайта stackoverflow.com

Can we use distinct in ORDER BY clause?

Either DISTINCT doesn't work (because the added extended sort key column changes its semantics), or ORDER BY doesn't work (because after DISTINCT we can no longer access the extended sort key column).

How do I SELECT distinct by ORDER BY?

1 Answer1SELECT DISTINCT Category, MAX(CreationDate)2FROM MonitoringJob.3GROUP BY Category.4ORDER BY MAX(CreationDate) DESC, Category.

What is a key difference between the distinct and ORDER BY statements in SQL SELECT commands?

Which line should go at the end of this statement? AND CUSTNUM>1000; What is a key difference between the DISTINCT and ORDER BY statements, in SQL SELECT commands? ORDER BY modifies the presentation of data results and DISTINCT filters data results.

Can a view have ORDER BY clause in the SELECT statement?

A view cannot be sorted with an ORDER BY clause. You need to put the ORDER BY clause into any query that references the view. Results of queries are ordered for display in the client application; rows in views and tables are unordered.

Expert · Answer