I want the query to returns the values in a specified order.
I want order by modified date first, then created date....easy enough right?
order by modified_date, created_date
The problem is, that in the modified date is not always filled in, so its null, so when I do the above query, the nulls are listed first in the results..but I want records with value in that field to be shown first..then sorted by the second column of created_date....then the null fields for modified_date are shown after that...
is this possible?