常用SQL Server：取所有类型的前10条并排序
表结构：ID, Category(类型), PubTiime(发布时间)
MS-SQL:
SELECT
t.*
FROM tb AS t
WHERE ID IN (SELECT TOP 10
ID
FROM
tb
WHERE Category
=
t.Category
ORDER BY PubTiime
DESC)
ORDER BY t.PubTime
DESC
SQLite:
SELECT
t.*
FROM tb AS t
WHERE ID IN (SELECT ID
FROM
tb
WHERE Category
=
t.Category
ORDER BY PubTime
DESC
LIMIT 0,
10)
ORDER BY t.PubTime
DESC
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16436858/viewspace-625920/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
