Interested to Buy Any Domain ? << Click Here >> for more details...
How to list Top 10 salary, without using Rank Transmission?
- 16 Answers
- 44562 Views
- Infosys, I also Faced
- E-Mail Answers
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
How to extract sap data using informatica?
What are the types of caches in lookup?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What is a filter transformation?
How to create Target definition for flat files?
Scheduling properties,whats the default (sequential)
What are the types of lookup transformation?
How to handle decimal places while importing a flatfile into informatica?
Write the unconnected lookup syntax?
Is it possible to create multiple domains on a single Informatica server?
What are the new features of informatica 9.x developer?
What is rank transformation?
Why do we need informatica?
How will the document be delivered to me?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
