View previous topic :: View next topic |
Author |
Message |
siva233 Beginner
Joined: 22 Mar 2006 Posts: 10 Topics: 8
|
Posted: Wed Mar 22, 2006 12:43 am Post subject: how to retrieve 5th row only from a table? |
|
|
I would like to know the sql query(a single query)to retrieve 5th row only from db2 table. |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12360 Topics: 75 Location: San Jose
|
Posted: Wed Mar 22, 2006 5:47 am Post subject: |
|
|
siva233,
5th row of what? 5th row as in the row insert sequence of the table or 5th row as in result set
Kolusu _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
siva233 Beginner
Joined: 22 Mar 2006 Posts: 10 Topics: 8
|
Posted: Thu Mar 23, 2006 1:09 am Post subject: |
|
|
hi,
Both for inserted sequence and result set
thanks
siva |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12360 Topics: 75 Location: San Jose
|
Posted: Thu Mar 23, 2006 6:42 am Post subject: |
|
|
siva233,
You will not able to retrieve based on the insert sequence unless the table has a Rownumber column.
Kolusu _________________ Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
siva233 Beginner
Joined: 22 Mar 2006 Posts: 10 Topics: 8
|
Posted: Thu Mar 23, 2006 11:46 pm Post subject: |
|
|
kolusu,
what is rownumber column?
thanks
siva |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12360 Topics: 75 Location: San Jose
|
|
Back to top |
|
|
|
|