when using 'order by' clause to sort columns in ascending order, rows with null value comes first.
what if the requirement is to sort in ascending order but rows with null values comes last?
use case.
select *
from table
order by case when column… more »