반응형
SMALL
select 5
from 1
where 2
groupby 3
having 4
order by 6
limit
from->where->groupby->having->select->order by
as cate gory, as 2021_gmv, as #mm
띄어쓰기, 숫자시작, 특수문자는 명명 X
단
as "cate gory", as "2021_gmv", as "#mm"
가능
반응형
LIST
'SQL > SQL Note' 카테고리의 다른 글
LIKE '%~%', Group by (0) | 2023.08.17 |
---|---|
패스트캠퍼스 SQL 복습 (0) | 2023.08.17 |
조회 조건, count 조건, hour, null (2) | 2023.08.17 |
SQL join 기본 (0) | 2023.08.16 |
LIMIT, YEAR, BETWEEN, DISTINCT (0) | 2023.08.16 |