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
hi real timers . iam waiting for ur reply regarding ETL TESTING
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What does cheating measurement mean?
What is enterprise data warehousing?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain the types of lookup transformation?
what is index?how it can work in informatica
Where do we use mapping variables in informatica?
What are the new features of informatica 9.x at the developer level?
What is the command used to run a batch?
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
What is the meaning of up gradation of repository?
What are the different options available for update strategy?
What are the limitations of joiner transformation?
Explain the informatica workflow?