select * from tablename order by primary_key desc fetch first 5 rows only

How will fetch last 5 rows from table in db2

Question Posted / mahyn

Answer Posted / mahyn

select * from tablename
order by primary_key desc
fetch first 5 rows only
with ur;

can be one way...

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many types of page locks can be held in db2?

1044

How to find the number of rows in db2 tables?

1073

What is difference between rollback and commit?

1167

what is diffrence b/w file-aid tool and file-aid utility???

4897

Why select is not preferred in embedded sql programs?

1307

What are host variables in db2?

1075

What is the max length of sqlca?

1221

what is db2 restart?

2164

define clustering index.

1036

What is a cursor in programming?

1076

What is the use of reorg in db2?

1089

How can you quickly find out the # of rows updated after an update statement?

1051

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3158

What does db2 stand for?

1033

Is ibm db2 open source?

1080