the above one is for fetching last record and i think u can decraese (use

quary for
1> fetch last record
2> fetch in reverse order
3> fetch last 5 row
4> fetch second last record (their is no primary key)
i think concept of count can be use for this in 4th

Question Posted / pavan

5 Answers
10307 Views
I also Faced
E-Mail Answers

Answer Posted / pavan

the above one is for fetching last record and i think u can
decraese (use < symbol) the count and use it for fetching
nth record in a table.

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to fetch the last row from the table in SQL (db2)?

1588

How many databases can be created inside an instance in db2 ?

977

define clustering index.

978

How do I copy a table in db2?

951

Can you use max on a char column?

1027

Is db2 free?

1036

What is temporal table in db2?

988

What is a db2 cursor?

1005

What db2 400?

1103

What is a bind in db2?

982

What's The Percentage Free Space ?

1157

What is rct?

1164

What are db2 objects?

1000

Explain about cursor stability?

981

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2865