limiting number of rows returned by resultset

natG

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

Thanks,
nat

Mar 29 '06 #1

Bernd Hohmann

natG wrote:

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

.... FETCH FIRST xx ROWS ONLY

Bernd

Mar 29 '06 #2

Eric.Jones

Bernd Hohmann wrote:

natG wrote:

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/infoce...n/c0005280.htm
Eric

Mar 30 '06 #3

natG

On Thu, 30 Mar 2006 10:11:32 +0200, Eric.Jones wrote:

Bernd Hohmann wrote:

natG wrote:

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/infoce...n/c0005280.htm
Eric

Thank you much.
nat

Mar 30 '06 #4