/SQL/SQL SERVER ORDER BY DATE NULL LAST

SQL SERVER ORDER BY DATE NULL LAST

Sql server order by nulls last

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

0

Source: dba-presents.com

SQL SERVER ORDER BY DATE NULL LAST

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

0

Source: stackoverflow.com

Similar codes

0 vote327 views2 answers
Faster mysql imports
SQL
0 vote306 views1 answer
Sqlite3 get data from table c
SQL
0 vote342 views3 answers
How to verify sequence result in oracle SQL
SQL
0 vote304 views1 answer
Sql inserted
SQL
0 vote310 views1 answer
Mysql query single row
SQL
20 votes333 views3 answers
How to open postgresql in mac
SQL
0 vote306 views1 answer
Codigo crear tablas sql server
SQL
18 votes306 views3 answers
Mysql number format
SQL
0 vote331 views1 answer
Oracle for loop on list
SQL
53 votes617 views6 answers
How to install mysql ubuntu
SQL

Share