1.騰訊筆試(從結(jié)果集中查詢)
select fuin,fscore from (select fuin,fscore,count(fuin) as num from t_score group by FUin order by fscore desc) as b where b.num>=2;
2.
1.騰訊筆試(從結(jié)果集中查詢)
select fuin,fscore from (select fuin,fscore,count(fuin) as num from t_score group by FUin order by fscore desc) as b where b.num>=2;
2.