Explicit Null Ordering with NULLS FIRST/LAST

Snippet

Explicit Null Ordering with NULLS FIRST/LAST

Standard SQL sorting behavior for NULL values varies by implementation. Using 'NULLS FIRST' or 'NULLS LAST' explicitly controls where NULL values appear in the result set, ensuring consistent behavior across different database systems regardless of their defaults.

snippet.sql

sql

SELECT product_name, discount_price
FROM inventory
ORDER BY discount_price DESC NULLS LAST, product_name ASC;

Breakdown

ORDER BY discount_price DESC

Sorts prices from highest to lowest.

NULLS LAST

Ensures that products with no discount (NULL) appear at the end of the list.

product_name ASC

Secondary sort criteria to maintain deterministic ordering.

Previous snippet Next snippet

More Expert SQL exercises →

From your library

Explicit Null Ordering with NULLS FIRST/LAST

Related