How to use DISTINCT and ORDER BY in same SELECT statement?

by

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, and use a GROUP BY to make the DISTINCT work.

Try something like this:

SELECT DISTINCT Category, MAX(CreationDate) 
FROM MonitoringJob 
GROUP BY Category 
ORDER BY MAX(CreationDate) DESC, Category

More Related Contents:

  1. How do I (or can I) SELECT DISTINCT on multiple columns?
  2. Sort by column ASC, but NULL values first?
  3. MySQL: Alternatives to ORDER BY RAND()
  4. PostgreSQL DISTINCT ON with different ORDER BY
  5. Group by minimum value in one field while selecting distinct rows
  6. SQL best practice to deal with default sort order
  7. SQL Query – Using Order By in UNION
  8. When no ‘Order by’ is specified, what order does a query choose for your record set?
  9. SQL how to make null values come last when sorting ascending
  10. How to use Oracle ORDER BY and ROWNUM correctly?
  11. How do I return rows with a specific value first?
  12. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  13. How to use SQL Order By statement to sort results case insensitive?
  14. SQL to find the number of distinct values in a column
  15. How to ORDER BY a SUM() in MySQL?
  16. sql query distinct with Row_Number
  17. SQLite and custom order by
  18. PostgreSQL ORDER BY issue – natural sort
  19. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  20. Alphanumeric sorting with PostgreSQL
  21. Sorting string column containing numbers in SQL?
  22. SQL ORDER BY date problem
  23. “Order By” using a parameter for the column name
  24. MySQL: Select DISTINCT / UNIQUE, but return all columns?
  25. SQL for ordering by number – 1,2,3,4 etc instead of 1,10,11,12
  26. SQL distinct for 2 fields in a database
  27. Select distinct from multiple fields using sql
  28. SQL ORDER chars numerically
  29. Dynamic order direction
  30. Curious issue with Oracle UNION and ORDER BY

Leave a Comment