怎么样
select id, name, city, state, selcount from t where exists( select 1 from (select name, city, state, max(selcount) selcount from t group by name, city, state) s where s.name = t.name and s.city = t.city and s.state = t.state and s.selcount = t.selcount)
我为此构建了一个SQL Fiddle，以显示一个有效的示例。
