常用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博客 ” ，链接：http://blog.itpub.net/16436858/viewspace-625920/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16436858/viewspace-625920/