How to list Top 10 salary, without using Rank Transmission?
Answer Posted / chinthi
SELECT t.sal from ( SELECT sal, Row_Number() OVER (ORDER
BY sal desc) AS rownum FROM table ) t WHERE t.rownum <=
10
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does command task mean?
What is meant by query override?
whats the logic to load the lower level of granularity of data to fact table.
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the new features of informatica 9.x developer?
What are the main issues while working with flat files as source and as targets ?
Which version configuration tool used in ur project?
What are the transformations that are not supported in mapplet?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What all join we can perform in LOOKUP transformation?
What is blocking transformation?
What is the benefit of partitioning a session?
Explain what are the different types of transformation available in informatica.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
permutations of mapplet