---
lang: ja-jp
breaks: true
---
# SQL ServerのORDER BYでNULL値を最後に並び替える方法 2025-05-19

## 通常の昇順で並び替え

select
	n.number
from
	(
		select null as number
		union select 1 as number
		union select 2 as number
	) as n
order by
	n.number
;


## null を最後にして昇順で並び替え

select
	n.number
from
	(
		select null as number
		union select 1 as number
		union select 2 as number
	) as n
order by
	-n.number desc    -- null を最後にしたいので `-1`を掛けて 降順にする。
;


###### tags: `SQL Server` `null` `並び替え` `ORDER BY`