MVSFORUMS.com

guptaji · Posted: Tue Jan 23, 2007 10:44 pm Post subject: fetching row

Hi,
suppose there are 100 records in a table, I want to select 10records starting from 11th to 20th. What query should I use?

Thanks

hareshh · Beginner Joined: 13 Dec 2006 Posts: 16 Topics: 0

Query:
SELECT rowid_column, column_name FROM table_name
GROUP BY rowid_column, column_name HAVING rowid_column BETWEEN 11 AND 20

If you want to know about rowid column refer link:
http://www.mvsforums.com/helpboards/viewtopic.php?t=627&highlight=rowid

Regards,
Haresh.

kolusu · Posted: Wed Jan 24, 2007 7:03 am Post subject:

guptaji,

If you have DB2 Version 8 then check this link. The link shows how to sequence your result set. Using the seqnuence # you can pick the desired rows.

http://www-1.ibm.com/support/docview.wss?fdoc=imdb2z&rs=64&uid=swg27005359

http://www-1.ibm.com/support/docview.wss?rs=64&uid=swg27006576

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu