글
SELECT
- 모든 데이터 가져오기
1 | SELECT * FROM dbo.Employee |
- 특정 열의 데이터 가져오기
1 | SELECT EmpID, HireDate, Email |
2 | FROM dbo.Employee |
3 | GO |
-특정 행의 데이터만 가져오기
1 | SELECT * |
2 | FROM dbo.Employee |
3 | WHERE EmpID = 'S0005' |
4 | GO |
- 특정 열의 특정 행만 가져오기
1 | SELECT EmpID, EmpName, HireDate, EMail |
2 | FROM dbo.Employee |
3 | WHERE EmpID = 'S0005' |
4 | GO |
- 비교 연산자 사용
1 | SELECT EmpID, EmpName, HireDate, EMail |
2 | FROM dbo.Employee |
3 | WHERE Salary >= 8000 |
4 |
5 | SELECT EmpID, EmpName, HireDate, EMail |
6 | FROM dbo.Employee |
7 | WHERE HireDate < '2007-01-01' |
- 문자열 비교
1 | SELECT EmpID, EmpName, HireDate, Email |
2 | FROM dbo.Employee |
3 | WHERE EmpName = '홍길동' |
4 |
5 | SELECT EmpID, EmpName, HireDate, Email |
6 | FROM dbo.Employee |
7 | WHERE EmpName LIKE '김%' |
- 논리 연산자 사용
01 | SELECT EmpID, EmpName, HireDate, EMail |
02 | FROM dbo.Employee |
03 | WHERE HireDate >= '2008-01-01' AND Salary >= 6000 |
04 |
05 | SELECT EmpID, EmpName, HireDate, EMail |
06 | FROM dbo.Employee |
07 | WHERE HireDate >= '2008-01-01' OR Salary >= 6000 |
08 |
09 | SELECT EmpID, EmpName, HireDate, EMail |
10 | FROM dbo.Employee |
11 | WHERE HireDate >= '2008-01-01' AND NOT Salary >= 6000 |
- 범위 조건 지정
1 | SELECT EmpID, EmpName, HireDate, EMail |
2 | FROM dbo.Employee |
3 | WHERE Salary BETWEEN 6000 AND 8000 |
4 |
5 | SELECT EmpID, EmpName, HireDate, EMail |
6 | FROM dbo.Employee |
7 | WHERE Salary >=6000 AND Salary <= 8000 |
- 리스트 조건 지정
1 | SELECT EmpID, EmpName, HireDate, EMail |
2 | FROM dbo.Employee |
3 | WHERE DeptID IN ('SYS', 'MKT', 'HRD') |
4 |
5 | SELECT EmpID, EmpName, HireDate, EMail |
6 | FROM dbo.Employee |
7 | WHERE DeptID = 'SYS' OR DeptID = 'MKT' OR DeptID = 'HRD' |
'MSSQL 2008 > SQL' 카테고리의 다른 글
| UPDATE 기본 문법 (0) | 2014.03.03 |
|---|---|
| INSERT 기본 문법 (0) | 2014.03.03 |
| DB에서 컬럼 이름 찾기 - MS SQL (0) | 2014.02.26 |
| SQL Server 에서 GO의 의미 (Batch) (0) | 2014.01.20 |
| SET 옵션들 (0) | 2014.01.13 |
