[MSSQL] CASE WHEN 구문

mssql에서 case when를 처리하는 문법

	/*
	https://docs.microsoft.com/ko-kr/sql/t-sql/language-elements/case-transact-sql?view=sql-server-ver15
	*/
	--Simple CASE expression
	SELECT ListName,
	CASE ListId
	WHEN 1 THEN 'ListId_1'
	WHEN 2 THEN 'ListId_2'
	WHEN 3 THEN 'ListId_3'
	WHEN 3 THEN 'ListId_4'
	ELSE 'ListId_else'
	END AS 'ListId'
	FROM dbo.Lists WITH(NOLOCK)
	--Searched CASE expression
	SELECT ListName,
	CASE
	WHEN ListId IN (1,2) THEN 'ListId_1_2'
	WHEN ListId IN (3,4) THEN 'ListId_3_4'
	ELSE 'ListId_Else'
	END AS 'ListId'
	FROM dbo.Lists WITH(NOLOCK)

view raw mssql_case_when.sql hosted with ❤ by GitHub