What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / biswa
select distinct(e1.sal) from emp e1 where &n=(select count(distinct(e2.sal)) from emp e2 where e1.sal <=e2.sal)
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is the difference between Active and Passive transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How can repository reports be accessed without sql or other transformations?
have u done any performance tuning? how u ll do?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the use of an aggregator cache file?
How would you join a node to the already existing domain?
How might you approve all mappings in the archive all the while?
What are the new features of Power Center 5.0?
Explain informatica architecture - version 8 / 9
What is source qualifier transformation in informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the difference between router and filter?