<SQL>[SELECT][FROM]

Flower in my dev/SQL

<SQL>[SELECT][FROM]

꽃선생 2017. 1. 30. 22:02

[SELECT][FROM]

1. 사용 방법

- 단일 컬럼

1
2
3
4
5
6
7
8
9
select some_colomn01
from some_table01;
 
select 
some_colomn01
from 
some_table01;
 
select some_colomn01 from some_table01;
cs

- 다중 컬럼

1
2
3
4
5
6
7
8
9
select some_colomn01, some_colomn02
from sometable01;
 
select 
some_colomn01, some_colomn02
from 
sometable01;
 
select some_colomn01, some_colomn02 from sometable01;
cs

- 전체 컬럼

1
2
3
4
5
6
7
8
9
select *
from sometable01;
 
select 
*
from 
sometable01;
 
select * from sometable01;
cs

( * 와일드카드 문자 : 전체)

2. 출력 결과 정하기 & 주석

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
select top 5 some_colomn01
from sometable01;
--MSSQL
 
select some_colomn01
from sometable01
fetch first 5 rows only;
--DB2
 
select some_colomn01
from sometable01
where rownum <= 5;
--oracle
 
select some_colomn01
from sometable01
limit 5;
--MySQl, MariaDB, PostgreSQL, SQLite
 
select some_colomn01
from sometable01
limit 5 offset 2;
cs

- offset은 시작위치를 지정

저작자표시 (새창열림)