28.MS_SQL 2008 - 서브쿼리문 [1]

--서브쿼리문

--[1]샘플테이블생성

Create Table dbo.Members

(

       Num Int Identity(1, 1) Not Null Primary Key, --일년번호

       Name VarChar(25) Not Null,                   --이름

       Age TinyInt Null,                            --나이

       Address VarChar(100) Null                    --주소

)

Go

--[2] 예시데이터입력

Insert Into Members(Name, Age, Address)

Values('홍길동', 21, '서울')

Go

Insert Members Values('백두산', 100, '부산')

Go

Insert Members Values('한라산', 30, '부산')

Go

--[3] 데이터조회(출력)

Select *From Members

Go

---

28SubTSQL(1).sql