Wednesday, January 27, 2010

Nulls at the top or bottom

Nulls at the top or bottom

order by asc --> by default arranges the null values at the bottom
order by desc --> by default arranges the null values at the top
we place null values at the top when 'order by asc'
and nulls at the bottom when 'order by desc' is used by using the keyword 'nulls first or nulls last' in the order by caluse

No comments: