29.MS_SQL 2008 - 서브쿼리문 [2]

--[!]하위커리(서브쿼리)

--3번인데이터의나이보다큰데이터만출력

 

-- [a] 3번레코드의나이

Select Age From Members Where Num = 3

--[b] 3번레코드의나이보다큰데이터출력

Select *From Members where Age > 30

 

 

--[a] 3번레코드의나이--26~29번을개선한것

Declare @intAge Int

Select @intAge = Age From Members Where Num = 3

--[b] 3번레코드의나이보다큰데이터출력

Select *From Members Where Age > @intAge

 

--[!]최종: 서브쿼리는기본적으로스칼라값이반환되어져야함 --32~36을개선한최종

Select *From Members

Where Age > (Select Age From Members Where Num = 3)

Go

--Select Age From Members Where Num = 3 : 단일값(스칼라값)으로출력

---

29SubTSQL(2).sql