一个简单的sql

ID Name subject Score
1 小明 A 12
2 小明 B 20
3 小王 A 1
4 小明 C 100
5 小王 E 23
6 小张 A 33
7 小王 B 3

select name from (SELECT name, sum(score) as sum_score FROM `grade` group by Name) as temp where sum_score > 100;
--
caosuwei <caosuwei@gmail.com>