SELECT * FROM (SELECT * FROM T ORDER BY pk DESC FETCH FIRST 5 ROWS) AS X O

How will fetch last 5 rows from table in db2

Question Posted / mayur bhayani

6 Answers
17669 Views
I also Faced
E-Mail Answers

Answer Posted / mayur bhayani

SELECT * FROM (SELECT * FROM T ORDER BY pk DESC FETCH FIRST 5 ROWS) AS X
ORDER BY PK;

Is This Answer Correct ?

3 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is package in cobol db2?

1074

Are views updateable?

1067

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2175

What is the result of open cursor statement?

1027

Which isolation level provides maximum concurrency?

1088

What are catalog tables in db2?

979

What os does db2 run on?

923

Define predicate?

1063

What is database reorganization?

1051

What is view db2?

1004

What does db2 blu stand for?

1100

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1003

What is page size in db2?

906

What is bind plan?

975

What is nvl in db2?

1039