티스토리 뷰

🌈 MsSql

영문순으로 정렬(order by)

James Wetzel 2023. 3. 24. 11:12
728x90
반응형
	select 
		xso.packing_no
	,	max(xso.seller_id)
	from dbo.table as xso with(nolock)
	where xso.packing_no in (
		select distinct [value]
		from string_split(@packing_no, ',')
	)
	group by xso.packing_no
	-- 영문순으로 정렬
	order by case when max(xso.seller_id) like '[a-za-z]%' then 0 else 1 end
	, max(xso.seller_id)
728x90
반응형