How do I make nulls comes first in a sort?

Question

When I order dates, sql puts nulls as the lowest value, but C# rdlc puts a null as the highest value. How do I solve it?

Google is your friend :) http://stackoverflow.com/questions/821798/order-by-date-showing-nulls-first-then-most-recent-dates — AlbertVo, Nov 10 '15 at 22:19

score 2 · Answer 1 · answered Nov 10 '15 at 22:19

2

ANSI SQL and some databases support the NULLS FIRST/NULLS LAST keywords, just for this purpose.

Otherwise, you can use explicit logic in a SQL query:

order by (case when col is null then 1 else 2 end),
         col

answered Nov 10 '15 at 22:19

Gordon Linoff

1 Answers1