How do I limit the number of rows returned in a Netezza query?

Question

I want to run a basic query, but return only the first ten rows of the table from Netezza

select a.*
  from some_schema.some_table a
 where rownum < 10

What is the Netezza way of looking at just those few rows?

It's not really the "First ten rows of the table", it's just SOME 10 rows from the table. First implies order. Without Order By tables have no order. — Stephanie Page, May 26 '10 at 16:51

score 7 · Accepted Answer · edited Mar 01 '21 at 11:17

7

Ah! Just found it.

For Netezza this query is

select a.*
  from some_schema.some_table a
 limit 10

-mcpeterson

edited Mar 01 '21 at 11:17

DineshDB

5,998
7
33
49

answered Mar 19 '10 at 18:15

mcpeterson

4,894
4
24
24

score 4 · Answer 2 · edited Jul 09 '14 at 08:23

4

SELECT * FROM schema_name..table_name LIMIT 100 OFFSET 50

LIMIT is number of records you need, and OFFSET is from where to count!

edited Jul 09 '14 at 08:23

Logan Wayne

6,001
16
31
49

answered Jul 09 '14 at 08:01

user2894697

41
4

score 2 · Answer 3 · edited Nov 17 '11 at 20:33

2

The below query should work for any random 'N' rows in a netezza table.

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 )

edited Nov 17 '11 at 20:33

Brandon

68,708
30
194
223

answered Nov 17 '11 at 18:50

Teja

13,214
36
93
155

How do I limit the number of rows returned in a Netezza query?

3 Answers3