-
<SQL>[SELECT][FROM]Flower in my dev/SQL 2017. 1. 30. 22:02
[SELECT][FROM]
1. 사용 방법
- 단일 컬럼
123456789select some_colomn01from some_table01;selectsome_colomn01fromsome_table01;select some_colomn01 from some_table01;cs - 다중 컬럼
123456789select some_colomn01, some_colomn02from sometable01;selectsome_colomn01, some_colomn02fromsometable01;select some_colomn01, some_colomn02 from sometable01;cs - 전체 컬럼
123456789select *from sometable01;select*fromsometable01;select * from sometable01;cs ( * 와일드카드 문자 : 전체)
2. 출력 결과 정하기 & 주석
12345678910111213141516171819202122select top 5 some_colomn01from sometable01;--MSSQLselect some_colomn01from sometable01fetch first 5 rows only;--DB2select some_colomn01from sometable01where rownum <= 5;--oracleselect some_colomn01from sometable01limit 5;--MySQl, MariaDB, PostgreSQL, SQLiteselect some_colomn01from sometable01limit 5 offset 2;cs - offset은 시작위치를 지정
'Flower in my dev > SQL' 카테고리의 다른 글
<SQL>[AND][OR] (0) 2017.02.02 <SQL>[WHERE] (0) 2017.02.02 <SQL>[ORDER BY] (0) 2017.02.01 SQL 이해 (0) 2015.01.07