同一个表中查询每个分类的前5条数据
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.Typ
原创
2021-12-31 14:44:57 ·
1054 阅读 ·
0 评论