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
- 9176 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 query_cache_limit?
How does a cursor work?
What is the cobol picture clause of the db2 data types date, time, timestamp?
Why do chiropractors use drop table?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
How can we read records for specific member in CL? AND rpg?
What is load replace in db2?
How to compare data between two tables in db2?
What happens in bind step in a db2 program?
What is the maximum No of rows per page?
What is clone table?
What is concurrency?
What is the result of open cursor statement?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is the max length of sqlca?
