How to list Top 10 salary, without using Rank Transmission?
Answer Posted / chandu
select distinct a.sal from emp a where 10>=(select
count(distinct b.sal from emp b where a.sal<=b.sal)order by
a.sal desc
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the benefit of session partitioning?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Under what condition selecting sorted input in aggregator may fail the session?
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
Explain the informatica workflow?
How to improve the performance of a session using sorter transformation?
What is the difference between writing a joiner query in ANSI style and THETA style?
Tell me about MD5 functions in informatica
How would you copy the content of one repository to another repository?
What does cheating measurement mean?
How we can use union transformation?
What is the scenario which compels informatica server to reject files?
What is a filter transformation and why it is an active one?
What is a dimensional model?
What are the popular informatica products?