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
Global and Local shortcuts. Advantages.
tell me about your project functionality
What are different types of transformations available in informatica?
How union transformation is used?
What are the transformations that are not supported in mapplet?
expain about the tune parameters?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
wf dont have integration severances how you can run?
How to use pmcmd utility command?
How do you use reject loader.
How do you migrate data from one environment to another?
Mention some types of transformation?
What do think which one is the better joiner or look up?
What are the various types of transformation?
Please let me know how to make encryption and decryption with example?