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....?
- 3 Answers
- 9153 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
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is meant by union and union all?
define clustering index.
List out the buffer pools in db2
What is scrollable cursor in db2?
is it compulsory commitment control in journal?
How can we read records for specific member in CL? AND rpg?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is dbrm in db2 database?
What is sqlca’s maximum length?
How do I import data from excel to db2?
What is explain plan in db2?
What is the difference between cursor and select statement?
What is db2 bind?
When do you specify the isolation level?
