SQL - Move nulls to end of ORDER BY clause - SQL Snipplr Social Repository

Revision: 52985

at November 9, 2011 02:47 by danfsmith

Initial Code

select custid, region
from [Sales].[Customers]
order by 
	case when region IS NULL THEN 1 ELSE 0 END, region;

Initial URL

Initial Description

Initial Title

SQL - Move nulls to end of ORDER BY clause

Initial Tags

Initial Language

SQL