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
10607 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 a storage group (stogroup)?

1248

what is the responsibility of the construction superintendent

2149

What is the purpose of using commit?

1100

How does a cursor work?

994

How to create backup table in db2?

1096

can we view the access paths created by dbrm ? how ? thx

7102

Mention some fields that are a part of sqlca.

1041

What is syscat in db2?

1017

What is null in db2?

1030

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2046

What is role in db2?

1110

What is db2 stogroup?

1164

What are the uses of db2 optimizer?

1299

Is db2 a database?

980

How to test SQL -911 error while developing COB-DB2 program

7579