---方法1 Select * From WZ_list As T Where ID In (Select Top 10 ID From WZ_list Where sclassid=T.sclassid Order By ID Desc) Order By sclassid,ID Desc---方法2 Select * From WZ_list As T Where (Select Count(1) From WZ_list Where sclassid=T.sclassid And ID>=T.ID)<11 Order By sclassid,ID Desc---方法3 Select * From WZ_list As T Where Not Exists (Select 1 From WZ_list Where sclassid=T.sclassid And ID>=T.ID Group By sclassid Having Count(1)>10) Order By sclassid,ID Desc
Select * From WZ_list As T Where ID In
(Select Top 10 ID From WZ_list Where sclassid=T.sclassid Order By ID Desc)
Order By sclassid,ID Desc---方法2
Select * From WZ_list As T Where
(Select Count(1) From WZ_list Where sclassid=T.sclassid And ID>=T.ID)<11
Order By sclassid,ID Desc---方法3
Select * From WZ_list As T Where Not Exists
(Select 1 From WZ_list Where sclassid=T.sclassid And ID>=T.ID Group By sclassid Having Count(1)>10)
Order By sclassid,ID Desc