SQL/SQL Note

SQL실행 순서, select 컬럼명, where 절 조건

hoonssss 2023. 8. 17. 09:25
반응형
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