Hi
The above query sent by me will work only in DB2 version 7.0 and above.
Regards
Abhi
How to get the last 10 records from a table
Re: How to get the last 10 records from a table
by progressabhi1 » Wed Apr 30, 2008 5:14 pm
- progressabhi1
- Posts: 17
- Joined: Tue Apr 01, 2008 6:07 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: How to get the last 10 records from a table
by CICS Guy » Wed Apr 30, 2008 7:24 pm
Are you saying that you do not have version 7? What version do you have?progressabhi1 wrote:The above query sent by me will work only in DB2 version 7.0 and above.
- CICS Guy
- Posts: 246
- Joined: Wed Jun 20, 2007 4:08 am
- Has thanked: 0 time
- Been thanked: 0 time
Re: How to get the last 10 records from a table
by dick scherrer » Wed Apr 30, 2008 9:53 pm
Hello,
What if seq_no is not a numeric field?
What if seq_no is not a numeric field?
Hope this helps,
d.sch.
d.sch.
-
dick scherrer - Global moderator
- Posts: 6268
- Joined: Sat Jun 09, 2007 8:58 am
- Has thanked: 3 times
- Been thanked: 93 times
Re: How to get the last 10 records from a table
by progressabhi1 » Tue May 06, 2008 9:36 am
"Are you saying that you do not have version 7? What version do you have?"
Hi
I mean to say that "FETCH FIRST 20 ROWS ONLY" works in ver7 & above as per my knowledge.I'm using version 7.1.
Regards
Abhi
Hi
I mean to say that "FETCH FIRST 20 ROWS ONLY" works in ver7 & above as per my knowledge.I'm using version 7.1.
Regards
Abhi
- progressabhi1
- Posts: 17
- Joined: Tue Apr 01, 2008 6:07 pm
- Has thanked: 0 time
- Been thanked: 0 time
Re: How to get the last 10 records from a table
by progressabhi1 » Tue May 06, 2008 9:38 am
dick scherrer wrote:Hello,
What if seq_no is not a numeric field?
Hi
Ya, u r correct.If its not numeric field than we will have to use concept of application programming & do any sorting e.g. radix sort etc.
Regards
Abhi
- progressabhi1
- Posts: 17
- Joined: Tue Apr 01, 2008 6:07 pm
- Has thanked: 0 time
- Been thanked: 0 time
-
- Related topics
- Replies
- Views
- Last post
-
- update table with more records
1, 2by pulcinella » Tue Jan 22, 2013 8:56 pm - 11 Replies
- 5012 Views
- Last post by dick scherrer
Fri Jan 25, 2013 2:08 am
- update table with more records
-
- How to copy Records from a DB2 table to a ps file
by shivam » Wed Aug 26, 2009 9:28 pm - 2 Replies
- 4928 Views
- Last post by jitender_2004bhiwani
Fri Nov 20, 2009 12:14 pm
- How to copy Records from a DB2 table to a ps file
-
- How to move last n records of a file into db2 table
by pradeepgowda » Fri Jan 22, 2010 2:10 pm - 1 Replies
- 2060 Views
- Last post by dick scherrer
Sat Jan 23, 2010 12:23 am
- How to move last n records of a file into db2 table
-
- need a query to delete duplicate records from a table
by var111 » Wed Nov 05, 2008 12:00 pm - 4 Replies
- 2763 Views
- Last post by var111
Fri Nov 07, 2008 4:13 pm
- need a query to delete duplicate records from a table
-
- Count records and compare with a field of a table
by vegafacundodaniel » Tue Oct 19, 2010 4:54 pm - 2 Replies
- 2223 Views
- Last post by GuyC
Tue Oct 19, 2010 6:54 pm
- Count records and compare with a field of a table