SQL SERVER ORDER BY DATE NULL LAST

Anxious Antelope answered on March 16, 2020 Popularity 8/10 Helpfulness 6/10

answer SQL SERVER ORDER BY DATE NULL LAST

related sql server order by nulls last

Comment

ORDER BY 
   IIF(Next_Contact_Date IS NULL, 1, 0),
   Next_Contact_Date;

Popularity 8/10 Helpfulness 6/10 Language sql

Tags: date null sql sql-server

Link to this answer
Share Copy Link

Contributed on Jan 06 2022

Anxious Antelope

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

SELECT *FROM creditCardORDER BY CASE WHEN monthlyLimit IS NULL THEN 1 ELSE 0 END DESC, monthlyLimit DESC;

Popularity 9/10 Helpfulness 3/10 Language sql

Source: dba-presents.com

Tags: sql-server sql s

Link to this answer
Share Copy Link

Contributed on Mar 16 2020

LeisureSuit Larry

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.