Details
-
Task
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
None
-
None
Description
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]"
Attachments
Issue Links
- links to
