How to select last 10 records from the table?

Abirami.YN · Posted: Sat Jul 16, 2005 3:59 pm

HI,

I have to display last 10 records and

3rd to 5 th record from the same table.

How can i do ?

parikshit123 · Active User Joined: 01 Jul 2005 Posts: 269 Location: India

Hi Abirami.YN,

In RDBMS, there is nothing like Nth record.

so, retriving 10 last records from a DB2 table doesn't make any sence.

Abirami.YN · Posted: Tue Jul 19, 2005 6:32 pm

HI Parikshit chudasma

We can retrive using the following code.
But i am getting -104 error.
I think this because of DB2 Version ( Iam not sure)

select * from (
select rownumber() over(order by fieldname) as r
from tablename
) as temptablename where r<= 10

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

Try this

Select * from table name fetch last 10 rows

radhakrishnan82 · Posted: Thu Aug 04, 2005 10:05 am

Fetch last 10 rows will do.

ovreddy · Posted: Fri Aug 05, 2005 2:35 pm

Hi,

SELECT * FROM <<TABLE NAME>> ORDER BY <<Primary Key>> DESC FETCH FIRST 10 ROWS ONLY;;

It will work. Don't say that u don't have a Primary Key. If So how can you say that these are last 10 records. If you do not agree on this give me a real time situation where we need this.

If you say that it is asked in some X Interview then ask them for a real situation. If they are really good enough about CODD'S rules they will agree with you.

Thanks,
Reddy.

thiagold · New User Joined: 29 Nov 2005 Posts: 3

dgrinch · New User Joined: 16 Nov 2005 Posts: 4

Not sure if it's for batch or online that u're asking. Ofcourse u might be using a Curosr, so use clauses DESC & OPTIMIZE FOR n ROWS assuming you will give a proper primary key values. The same can be done for first 5 rows and programatically maniplulate 3 & 5 th row. But 3rd & 5th row manipulation kinda strikes me odd. It doesn't really happen that way. Can you elaborate a bit on what you're trying to do? Hope this helps.