What's netezza's "rownum" equivalent? Or how do you take a "head" of a netezza table in netezza sql?

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?

Answer 1

Ah! Just found it.

For Netezza this query is select a.* from some_schema.some_table a limit 10

-mcpeterson