sql语句 求每学科前两名

select * from class a where id in (select top 2 id from class where subject= a.subject order by point desc) order by subject,point descselect * from class a where id in (select top 2