-
Type:
Task
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 1.22.0
-
Component/s: None
-
Labels:
MSSQL cannot handle NULLS LAST/FIRST and should emulate the NULLS LAST/FIRST in order by, i.e.
--for nulls last
select [column] from [table] ORDER BY CASE WHEN [column] IS NULL THEN 1 ELSE 0 END, [column]"
--for nulls first
select [column] from [table] ORDER BY CASE WHEN [column] IS NULL THEN 0 ELSE 1 END, [column]"
- links to