“SELECT a.*
FROM Article a
WHERE (ID IN
(SELECT TOP 3 id
FROM article
WHERE classid = a.classid))
ORDER BY ClassID, ID”
按分类取前三条记录
最新推荐文章于 2019-08-20 16:07:01 发布
“SELECT a.*
FROM Article a
WHERE (ID IN
(SELECT TOP 3 id
FROM article
WHERE classid = a.classid))
ORDER BY ClassID, ID”