Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql server order by nulls last

SELECT *FROM creditCardORDER BY CASE WHEN monthlyLimit IS NULL THEN 1 ELSE 0 END DESC, monthlyLimit DESC;
Source by dba-presents.com #
 
PREVIOUS NEXT
Tagged: #sql #server #order #nulls
ADD COMMENT
Topic
Name
7+3 =