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
- 10775 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 does reorg do in db2?
Is db2 a programming language?
What is a bind in db2?
How to fetch the last row from the table in SQL (db2)?
How do you pull up a query which was previously saved in qmf?
Can there be more than one cursor open for any program?
What is package in db2 mainframe?
How many databases can be created inside an instance in db2 ?
What is table space in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Explain in detail about buffer manager and its functionalities?
What is the physical storage length of date data type?
What is sqlca?
What is the role of schema in the db2 database?
