limiting number of rows returned by resultset

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

natG - 29 Mar 2006 23:49 GMT

Hi;
In db2 8.2, how do I limit a query resultset to x rows?

Thanks,
nat

Reply to this Message

Bernd Hohmann - 30 Mar 2006 00:01 GMT

> In db2 8.2, how do I limit a query resultset to x rows?

... FETCH FIRST xx ROWS ONLY

Bernd

Reply to this Message

Eric.Jones - 30 Mar 2006 09:11 GMT

>> In db2 8.2, how do I limit a query resultset to x rows?
>
> ... FETCH FIRST xx ROWS ONLY
>
> Bernd

If you intend to use this often, against large tables, consider also using:

... OPTIMIZE FOR xx ROWS

There's a good overview in the section: Guidelines for restricting select statements at:

http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.
udb.doc/admin/c0005280.htm

Eric

Reply to this Message

natG - 30 Mar 2006 18:40 GMT

>>> In db2 8.2, how do I limit a query resultset to x rows?
>>
[quoted text clipped - 11 lines]
>
> Eric

Thank you much.
nat

Reply to this Message