Interested to Buy Any Domain ? << Click Here >> for more details...
How to display last 5 records in a table ?
With out Top key word and doing order by desc
Advance thanks
- 2 Answers
- 6852 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / madhu
this is can acheieve by following query
select * from(select rowunum r,e.*from emp e) where
r>(select count(*)-5 from emp);
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the reusable transformations?
How you can differentiate between connected lookup and unconnected lookup?
what is $$$$?
What is the command used to run a batch?
Please let me know how to make Data masking in informatica..
How can we use batches?
What are the features of complex mapping?
What can we do to improve the performance of informatica aggregator transformation?
What is the use of target designer?
What is the meaning of up gradation of repository?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
What is sequence generator transformation in informatica?
Under what condition selecting sorted input in aggregator may fail the session?
What are the types of data warehouses?
