sqlν¨μ (1) μΈλ€μΌν 리μ€νΈν SQLκ°λ°μ-3: ORDER BY(μ λ ¬), WHERE(쑰건μ ) ν¨μ 1) ORDER BY (μ λ ¬) 2) WHERE (쑰건μ ) 2-1) BETWEEN 2-2) IN 2-3) LIKE 2-4) NULL 3) ν¨μ 4) GROUP BY, HAVING μ 1) ORDER BY (μ λ ¬) SELECT 컬λΌλͺ FROM ν μ΄λΈλͺ ORDER BY 컬λΌλͺ [ASC / DESC]; ASC μ€λ¦μ°¨μ μ λ ¬ (μλ΅ μ κΈ°λ³Έκ°) DESC λ΄λ¦Όμ°¨μ μ λ ¬ SELECTλ¬Έμ λ°λμ κ°μ₯ λ§μ§λ§μ μμΉ, μ¬λ¬ κ° μ§μ μ μμλλ‘ μ μ© NULLμ λΉκ΅ λΆκ° 2) WHERE 쑰건문: νΉμ 쑰건μ ν΄λΉνλ νμ μ‘°ν WHERE μ‘°κ±΄λ¬Έμ΄ μμΌλ©΄ λͺ¨λ λ°μ΄ν° μ‘°ν SELECT 컬λΌλͺ 1, 컬λΌλͺ 2 FROM ν μ΄λΈλͺ WHERE 쑰건; A = B Aμ Bκ° κ°λ€. A > B Aκ° Bλ³΄λ€ ν¬λ€. A < B Aκ° B.. μ΄μ 1 λ€μ
