同一个表中查询每个分类的前5条数据

落落的前端学习之路

于 2021-12-31 14:44:57 发布

阅读量1.1k

点赞数

分类专栏： C# asp.net sql 文章标签：数据挖掘人工智能 sql

本文链接：https://blog.youkuaiyun.com/qq_36904182/article/details/122256068

版权

C# asp.net 同时被 2 个专栏收录

5 篇文章

订阅专栏

sql

1 篇文章

订阅专栏

select a.Id,a.Type,a.Title,a.ShowTime,a.UserName,a.ExternalLinks,a.Cover,a.PlainText, a.IsState,count(*) as num 
from (select * from news  where  IsState=1 and IsDeleted=0) as a
inner join (select * from news where  IsState=1 and IsDeleted=0) as b ON a.Type=b.Type 
where  b.id>=a.id 
and   a.Type  in (0,2)   group by a.id having num<=5 order by a.type,num;