常用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/，如需轉載，請註明出處，否則將追究法律責任。