Use the below query to fetch first 100 rows among 1000 rows , select * f

in my table i will update only 100 record among 1000
records i need to display recently updated record'.....can u
tell me where those records are stored how can i display
those records...?if there is any sql query pls let me know....?

Question Posted / vikram

3 Answers
10597 Views
Infosys, I also Faced
E-Mail Answers

Answer Posted / vikram

Use the below query to fetch first 100 rows among 1000 rows ,

select * from table order by column desc fetch first 100 rows

column is either timestamp or id

so the above query gives recent 100 updated rows.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is rebind in db2?

1060

What is the use of runstats in db2?

1109

What is check constraint. Explain with example.

1107

What is nvl in db2?

1093

Mention the different locking levels that are available in db2.

1134

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2852

How can deadlocks be resolved?

935

How to connect to db2 database from windows command line?

1065

Can we insert update delete in view?

972

What is buffer pool and list some of them?

1028

what is the sqlcode -501

13150

What is the maximum size of a char data type in db2?

1010

How to rename a table in DB2 ?

1088

What is the use of reorg in db2?

1084

How do I optimize a query in db2?

1101