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 desc
这句显示了一个sql语句的精典写法,一般的select 语句都是逐行判断每条是否符合条件,所以我们的条件语句是可以写成动态的.
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 desc
这句显示了一个sql语句的精典写法,一般的select 语句都是逐行判断每条是否符合条件,所以我们的条件语句是可以写成动态的.