Posted By

danfsmith on 11/09/11

Tagged

Viewed 835 times

Favorited by 0 user(s)

/ Published in: SQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT custid, region
FROM [Sales].[Customers]
ORDER BY 
	CASE WHEN region IS NULL THEN 1 ELSE 0 END, region;

Comment:

You need to login to post a comment.