
[SQLD] μ΅μ’
μ 리
Β·
μ격μ¦/SQLD
λ¬Έμ₯ μ€ν μμ FROM - WHERE - GROUP BY - HAVING - SELECT - ORDER BY 1. λ°μ· λμ ν
μ΄λΈμ μ°Έμ‘° (FROM) 2. λ°μ΄ν°κ° μλ κ²μ μ κ±° (WHERE) 3. κ·Έλ£Ήν (GROUP BY) 4. κ·Έλ£Ήν 쑰건 (HAVING) 5. μΆλ ₯ (SELECT) 6. μ λ ¬ (ORDER BY) SQL λ¬Έμ₯λ€μ μ’
λ₯ λ°μ΄ν° μ‘°μμ΄(DML) : SELECT , INSERT , UPDATE , DELETE λ°μ΄ν° μ μμ΄(DDL) : CREATE , ALTER , DROP , RENAME λ°μ΄ν° μ μ΄μ΄(DCL) : GRANT , REVOKE νΈλμμ
μ μ΄μ΄(TCL) : COMMIT , ROLLBACK DISTINCT μ€λ³΅λ κ²½μ° 1κ±΄λ§ μΆλ ₯ λ°μ΄ν° κ·Έλ£Ήν/μ§κ³ (GROUP BY) κ°μ..