选择第8行之后的前3行
选择第8行之后的前3行
提问于 2013-01-28 08:12:06
我有一张桌子：id, Group, Status, Subject。
我需要行group=2和status=2，但我想跳过前8个结果(按id排序)。这就是我尝试过的，但它没有跳过前8行：
SELECT TOP 3 [id], LEFT ([subject],30) AS Title
FROM [Katavot]
WHERE (([Status] = @Status) AND ([Group] = @Group))
ORDER BY [id] DESC回答 3
Stack Overflow用户
回答已采纳
发布于 2013-01-28 08:24:43
;WITH Katavod_Modified AS
(
SELECT id, LEFT ([subject],30) As Subject, [Group], [Status], ROW_NUMBER() OVER (ORDER BY id) RN
FROM [Katavot]
)
SELECT TOP 3 [id], LEFT ([subject],30) AS Title FROM [Katavod_Modified] WHERE
(([Status] = @Status) AND ([Group] = @Group) AND (RN > 8)) ORDER BY [id] DESC 看起来与this one非常相似。
Stack Overflow用户
发布于 2013-01-28 08:27:46
基于row_number
WITH MyResult AS
{
SELECT ROW_NUMBER() OVER(ORDER BY Id DESC) AS RowNumber, [id], LEFT ([subject],30) AS Title
FROM [Katavot]
WHERE (([Status] = @Status) AND ([Group] = @Group))
ORDER BY [id] DESC
}
SELECT [id], Title
FROM MyResult
WHERE RowNumber BETWEEN 9 AND 12Stack Overflow用户
发布于 2013-01-28 08:28:10
MySQL：
LIMIT x, yMSSQL：
select top y *
from <table>
where <unique id> not in (select top x <unique id> from <table> order by <unique id>)
from <table> order by <unique id>页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/14553798
复制相关文章
相似问题
腾讯云开发者
