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

sql netezza

mcpeterson · Mar 19, 2010 · Viewed 32.8k times · Source

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?

Answer

Ah! Just found it.

For Netezza this query is

select a.*
  from some_schema.some_table a
 limit 10

-mcpeterson