搜索

+

95

-

回答

SELECT * FROM
(SELECT TOP "&pagesize&" * FROM
(SELECT TOP "&page*pagesize&" 字段 FROM 表 ORDER BY id DESC)
ORDER BY id)
ORDER BY id DESC
例子

SELECT * FROM 
(SELECT TOP 2 * FROM 
(SELECT TOP 2 id FROM table ORDER BY id DESC) 
ORDER BY id) 
ORDER BY id DESC

双top写法

网友回复

我知道答案，我要回答

我有问题

私活外包

最新提问