I have two columns, one is an int and the other is a date,
I want the records to show first the null values in the int column and have that sorted by date, then the rest of the rows sorted by date.
I tried doing
order by int asc, date asc, but it only orders the null values properly.
so this...