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

What does db2 blu stand for?

1110

How to create backup table in db2?

1056

What are the 2 sqlcodes that are returned?

1140

How does coalesce work?

970

What is the use of db2 optimizer?

1063

What is db2 look?

979

What is image copy in db2?

957

Explain about rct in db2?

1056

List out the buffer pools in db2

1029

How do I delete a table in database?

988

Explain about open switch business continuity software?

1082

What are the different types of base tables?

1042

Which command is used to connect to a database in DB2 ? Give the Syntax.

1048

How to check sequence on a table in db2?

1013

On which levels locks can be applied?

1070