Originally posted by MattR
I have some NULL values in a numeric column.. When I ORDER BY nullCol ASC, the NULLs sort 'high' (e.g. they appear last). How can I change it so that the NULLs sort 'low' (e.g. they appear first)?
It is a foriegn key so I can't set it to 0 or -1.
You can specify where NULLs appear like this:
SQL> select empno, mgr
2 from emp order by mgr nulls first;