SQL 如何限制 Netezza 查询中返回的行数？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2479556/
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
How do I limit the number of rows returned in a Netezza query?
提问by mcpeterson
I want to run a basic query, but return only the first ten rows of the table from Netezza
我想运行一个基本查询，但只从 Netezza 返回表的前十行
select a.*
from some_schema.some_table a
where rownum < 10
What is the Netezza way of looking at just those few rows?
Netezza 仅查看那几行的方式是什么？
回答by mcpeterson
Ah! Just found it.
啊! 刚找到。
For Netezza this query is select a.* from some_schema.some_table a limit 10
对于 Netezza，此查询是 select a.* from some_schema.some_table a limit 10
-mcpeterson
-麦克彼得森
回答by Teja
The below query should work for any random 'N' rows in a netezza table.
下面的查询应该适用于 netezza 表中的任何随机“N”行。
SELECT COLNAME1 FROM ( SELECT COLNAME1 FROM SCHEMANAME..TABLENAME ORDER BY COLNAME1 LIMIT n) A
MINUS
SELECT COLNAME1 FROM ( SELECT COLNAME1 FROM SCHEMANAME..TABLENAME ORDER BY COLNAME1 LIMIT m) B
Note : n>m ( m,n are integers )
注意：n>m（m,n 是整数）
回答by user2894697
SELECT * FROM schema_name..table_name LIMIT 100 OFFSET 50
LIMITis number of records you need, and OFFSETis from where to count!
LIMIT是您需要的记录数，OFFSET是从哪里开始计算！
