select * from t1 where f2 in ( select max(f2) from t1 group by f1)or:select a.*
from t1 a join
( select f1, max(f2) as f2
from t1
group by f1
) b
on a.f1=b.f1 and a.f2=b.f2
from t1 a join
( select f1, max(f2) as f2
from t1
group by f1
) b
on a.f1=b.f1 and a.f2=b.f2
这句错了,不要看它。