MySQL 从表中选择前 N 行
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/9150370/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
select the TOP N rows from a table
提问by Night Walker
I am making some paging, and I need to make some query and get the result form defined slicing . for example: I need to get all "top" rows in range 20n < x < 40n etc.
我正在制作一些分页，我需要进行一些查询并获取定义切片的结果形式。例如：我需要获取 20n < x < 40n 等范围内的所有“顶级”行。
SELECT * FROM Reflow
WHERE ReflowProcessID = somenumber
ORDER BY ID DESC;
and now I need to make my sliding by column called ID .
现在我需要按名为 ID 的列进行滑动。
Any suggestions how to so ? I need to run my query on mysql, mssql, and oracle.
有什么建议吗？我需要在 mysql、mssql 和 oracle 上运行我的查询。
回答by Bassam Mehanni
Assuming your page size is 20 record, and you wanna get page number 2, here is how you would do it:
假设您的页面大小是 20 条记录，并且您想要获得第 2 页，那么您可以这样做：
SQL Server, Oracle:
SQL Server、甲骨文：
SELECT * -- <-- pick any columns here from your table, if you wanna exclude the RowNumber
FROM (SELECT ROW_NUMBER OVER(ORDER BY ID DESC) RowNumber, *
FROM Reflow
WHERE ReflowProcessID = somenumber) t
WHERE RowNumber >= 20 AND RowNumber <= 40
MySQL:
MySQL：
SELECT *
FROM Reflow
WHERE ReflowProcessID = somenumber
ORDER BY ID DESC
LIMIT 20 OFFSET 20
回答by Eric
In MySql, you can get 10 rows starting from row 20 using:
在 MySql 中，您可以使用以下方法从第 20 行开始获取 10 行：
SELECT * FROM Reflow
WHERE ReflowProcessID = somenumber
ORDER BY ID DESC
LIMIT 10 OFFSET 20 --Equivalent to LIMIT 20, 10
回答by Pravin
select * from table_name LIMIT 100
remember this only works with MYSQL
记住这只适用于 MYSQL
