存在两张表。用一条sql,查询显示出人数最多的前5个班级的名称和人数。
select * from
(select c.name as name ,des.sumStudnet as sumStudent from (
select classid,count(*) as sumStudnet from student group by classid order by count(*) desc
) des left join class c on des.classid=c.id order by des.sumStudnet desc
) des1 where rownum<6