DB2 Equivalent of 'TOP' or 'FIRST' 1

[stoggers]

Hi,

Is there an equivalent in DB2 to the TOP or FIRST directive in other varieties of SQL - ie to return only the first n rows of a query.

If not, is there a query which will simulate TOP or FIRST.

Thanks,

Mike Stogden.

 

[tcrisman]

The obvious answer is to use "order by" to put the rows satisfying your select in the desired sequence, and close your cursor after nnn fetches.
The last issue of DB2 magazine indicates that with version 7, you can put in a "fetch first 1 row" on a query if only one row is required. I'm not sure what "fetch first 5 row" might yield.
See article:

http://www.db2mag.com/db_area/archives/2001/q3/programmers.shtml

 

[sgursahaney]

If you want the first 5 rows, you should use the clause:

FETCH FIRST 5 ROWS

It will act just like the SQL Server TOP clause.

Regards,
Suresh