How to order with count value=0
I have written a simple query that involves a count and outer join.
To get around the nulls an outer join may produce, i have used nvls(column,) so that nulls are replaced by 0
I wish now to order my records ascending by the count from 0 to infinity however I have found that 0 is considered to be order last
How can i get it to return
Is there a mask or something. Using to_number did not work and to_char is also not practical if your count is two digit number.
[ NULLS FIRST | NULLS LAST ]
Click Here to Expand Forum to Full Width