카테고리 없음
How to order by with union in SQL
리게인
2023. 1. 8. 17:39
300x250
반응형
Select id,name,age, 1 as rowOrder
From Student
Where age < 15
UNION
Select id,name,age, 2 as rowOrder
From Student
Where Name like "%a%"
Order by rowOrder, name
300x250
반응형