문법 · SQL · beginner

CASE · HAVING · LIKE

행 변환 CASE, 집계 후 HAVING, 패턴 LIKE.

배우기 · SQL 문법 · 12분 · 11/14 · sql · CASE · HAVING · LIKE

이 트랙 목차 (14)

CASE WHEN

SELECT id,
  CASE WHEN score >= 90 THEN 'A'
       WHEN score >= 80 THEN 'B'
       ELSE 'C' END AS grade
FROM scores;

GROUP BY 뒤 집계 조건을 겁니다.

SELECT dept, SUM(amt)
FROM sales
GROUP BY dept
HAVING SUM(amt) > 30;

WHERE w LIKE 'a%'

> 행 단위 CASE, 그룹 필터 HAVING, 글자 패턴 LIKE.