菜鸟提问简单的sql 要求效率高 ( 积分: 50 )

還可以寫成
select a.* from aa as a,(
select sname from aa
where cj='優'
group by sname
having count(*)=(select max(icount) from (select count(*) as icount from aa group by stime) as a)) as b
where a.sname=b.sname

多人接受答案了。