I am hoping I can get an answer to my question. I want to sort a column in
ascending order, but I want null values to sort to the bottom. A simple
ORDER BY ColumnA ASC sorts the column in ascending order with null vales
appearing on top. The following code, however, works correctly, but I have
no idea why: ORDER BY ColumnA IS NULL ASC, ColumnA ASC. Can someone please
explain why? I also tried ORDER BY ColumnA IS NULL ASC and this code sorted
only the null values to the bottom of the remaining unsorted list, which I
do not understand. I guess what I am not understanding is why the result of
filtering within an ORDER BY clause appears at the bottom of my list.
--
View this message in context:
http://old.nabble.com/Sorting-Question-tp31378319p31378319.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users