sql server order by nulls last
snippet in sql

sql server order by nulls last

user7846

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