problem with numbers order by
557899Jul 18 2008 — edited Jul 18 2008i have a requirement where i need to sort the records based on the number. I want the output like
-1,null,0,1,2,3 if asc.
3,2,1,0,null,-1 if desc
i am doing
select * from table order by col asc, but the null row is coming either last or first based on asc or desc.
please let me know how can i do it.