Sort NULL values to the end of a table

by

NULL values are sorted last in default ascending order. You don’t have to do anything extra.

The issue applies to descending order, which is the perfect inverse and thus sorts NULL values on top.
PostgreSQL 8.3 introduced NULLS LAST:

ORDER BY somevalue DESC NULLS LAST

For PostgreSQL 8.2 and older or other RDBMS without this standard SQL feature:

ORDER BY (somevalue IS NULL), somevalue DESC

FALSE sorts before TRUE, so NULL values come last, just like in the example above.

See:

More Related Contents:

  1. Sort by column ASC, but NULL values first?
  2. Sorting null values after all others, except special
  3. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  4. Select rows which are not present in other table
  5. PostgreSQL DISTINCT ON with different ORDER BY
  6. ORDER BY the IN value list
  7. Create unique constraint with null columns
  8. Optimize query with OFFSET on large table
  9. sql ORDER BY multiple values in specific order?
  10. Best way to check for “empty or null value”
  11. PostgreSQL ORDER BY issue – natural sort
  12. Alphanumeric sorting with PostgreSQL
  13. Combine two columns and add into one new column
  14. IN Clause with NULL or IS NULL
  15. Check if NULL exists in Postgres array
  16. Why does NULL = NULL evaluate to false in SQL server
  17. Possible to perform cross-database queries with PostgreSQL?
  18. GROUP BY and aggregate sequential numeric values
  19. Safely rename tables using serial primary key columns
  20. How to use (install) dblink in PostgreSQL?
  21. Postgres manually alter sequence
  22. What’s the proper index for querying structures in arrays in Postgres jsonb?
  23. Determine Oracle null == null
  24. Aggregate a single column in query with many columns
  25. Aggregating (x,y) coordinate point clouds in PostgreSQL
  26. Does Postgres support nested or autonomous transactions?
  27. PostgreSQL delete with inner join
  28. Why is iterating through a large Django QuerySet consuming massive amounts of memory?
  29. Update a column of a table with a column of another table in PostgreSQL
  30. Temporal database design, with a twist (live vs draft rows)

Leave a Comment