SQL multiple column ordering

by 
ORDER BY column1 DESC, column2

This sorts everything by column1 (descending) first, and then by column2 (ascending, which is the default) whenever the column1 fields for two or more rows are equal.

More Related Contents:

  1. Sort by column ASC, but NULL values first?
  2. ORDER BY the IN value list
  3. SQL best practice to deal with default sort order
  4. How to order by with union in SQL?
  5. SQL Query – Using Order By in UNION
  6. Optimize query with OFFSET on large table
  7. When no ‘Order by’ is specified, what order does a query choose for your record set?
  8. How to use DISTINCT and ORDER BY in same SELECT statement?
  9. sql ORDER BY multiple values in specific order?
  10. SQL how to make null values come last when sorting ascending
  11. How to use Oracle ORDER BY and ROWNUM correctly?
  12. Sorting null values after all others, except special
  13. Can I do a max(count(*)) in SQL?
  14. How to update and order by using ms sql
  15. How to ORDER BY a SUM() in MySQL?
  16. SQL Server UNION – What is the default ORDER BY Behaviour
  17. Sort NULL values to the end of a table
  18. SQLite and custom order by
  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. Custom Order in Oracle SQL
  25. SQL for ordering by number – 1,2,3,4 etc instead of 1,10,11,12
  26. SQLite Order By Date1530019888000
  27. how does SELECT TOP works when no order by is specified?
  28. How to get results in a custom order? [closed]
  29. SQL ORDER chars numerically
  30. Dynamic order direction

Leave a Comment