Oracle uses order by to sort null values. oracleorder

Oracle uses order by to sort null values. oracleorder

When order by is used in Oracle for query and sorting, if there is a null value in the sorting field, the sorting result may not reach the expected result. For example:

Select * from test order by age desc;

Sort by age field in descending order. The result is as follows:

Change the SQL statement

Select * from test order by age desc nulls last;

You can sort the null value to the end ." Nulls last "puts the null value behind, and the opposite" nulls first "puts the null value record before

Oracle defaults to null.

Sort in ascending order. By default, the null value is placed behind.

Sort in descending order. By default, the null value is ranked first.

Author: itmyhome