[转载]每个分类取5条, 这样的SQL如何写？？ – CSDN论坛 – CSDN.NET
- 开发笔记
- 2013-05-24
- 121热度
- 0评论
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)