专注于互联网--专注于架构

hack.sqlscan.a:only a sql

select a.id,a.name,a.scorefrom temp a,(select name,max(score) as max_score from temp group by name) bwhere a.name =b.nameand a.score=b.max_score [阅读全文] [PDF]