- 使用聚合函數進行分組
SELECT name, SUM(score) as total_score
FROM students
GROUP BY name
- 使用條件進行分組
SELECT
name,
SUM(CASE WHEN subject='Math' THEN score ELSE 0 END) as math_score,
SUM(CASE WHEN subject='English' THEN score ELSE 0 END) as english_score
FROM students
GROUP BY name
- 使用聚合函數進行排序
SELECT name, SUM(score) as total_score
FROM students
GROUP BY name
ORDER BY total_score DESC
- 使用聚合函數進行篩選
SELECT name, SUM(score) as total_score
FROM students
GROUP BY name
HAVING total_score > 200
- 使用窗口函數
SELECT name, score, SUM(score) OVER (PARTITION BY name) as total_score
FROM students
