SQL how to make null values come last when sorting ascending

by 
select MyDate
from MyTable
order by case when MyDate is null then 1 else 0 end, MyDate

More Related Contents:

  1. SQL Query – Using Order By in UNION
  2. Sorting null values after all others, except special
  3. How to use SQL Order By statement to sort results case insensitive?
  4. Alphanumeric sorting with PostgreSQL
  5. Sort by column ASC, but NULL values first?
  6. Natural Sort in MySQL
  7. SQL multiple column ordering
  8. ORDER BY the IN value list
  9. SQL best practice to deal with default sort order
  10. How to order by with union in SQL?
  11. Humanized or natural number sorting of mixed word-and-number strings
  12. Optimize query with OFFSET on large table
  13. How to use DISTINCT and ORDER BY in same SELECT statement?
  14. Dynamic Sorting within SQL Stored Procedures
  15. Can I do a max(count(*)) in SQL?
  16. How to update and order by using ms sql
  17. SQL Server UNION – What is the default ORDER BY Behaviour
  18. Sort NULL values to the end of a table
  19. PostgreSQL ORDER BY issue – natural sort
  20. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  21. “Order By” using a parameter for the column name
  22. SQL: ORDER BY using a substring within a specific column… possible?
  23. How Can I Sort A ‘Version Number’ Column Generically Using a SQL Server Query
  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. SQL ORDER chars numerically
  29. Dynamic order direction
  30. ORDER BY alphabet first then follow by number

Leave a Comment