Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10551 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
How do I add a column in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How do you pull up a query which was previously saved in qmf?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the usage of open cursor command?
What is netezza database?
When do you specify the isolation level?
Explain packages.
What is dpf in db2?
How to fetch the last row from the table in SQL (db2)?
What are bind parameters in db2?
What is buffer pool in the db2 database?
Explain in brief how does db2 determine what lock-size to use?
What is rct?
What are the various data types available in db2?
