可以这样写SQL语句:
select a.name,a.game,
b.g as TotalGameTime from
(select name,game,sum(duration) as gs
from tblName group by name,game) a,
(select name,max(gs) as g from (select name,game,sum(duration) as gs
from tblName group by name,game)
group by name) b where a.name=b.name
and a.gs=b.g;
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024