[转载]每个分类取5条, 这样的SQL如何写?? - CSDN论坛 - CSDN.NET
select * from table1 as t where date in (select top 5 date from talbe1 where class=t.class order by date desc) 通过[转载]每个分...
select * from table1 as t where date in (select top 5 date from talbe1 where class=t.class order by date desc) 通过[转载]每个分...