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
- 9835 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 collection in db2 bind?
What is dbrm?
What are types of indexes?
What is precompiler in db2?
Is it possible using max on a char column?
What is isolation level in db2?
What is the difference between spufi and qmf?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is database reorganization?
What do you mean by storage group (stogroup)?
Mention the different locking levels that are available in db2.
Is db2 relational database?
Mention the definition of cobol in varchar field.
What is the use of value function?
What is meant by explain?
