Interested to Buy Any Domain ? << Click Here >> for more details...
What is the query to find nth highest salary?
What is the use of cursors?
- 8 Answers
- 21187 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
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
What is incremental aggregation?
How to load a Dimension ? and how to load a fact table?
How many ways a relational source definition can be updated and what are they?
What is depict expression change?
What is the commit type if you have a transaction control transformation in the mapping?
Can u generate reports in Informatica?
How many number of sessions can one group in batches?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is informatica etl tool?
what is the complex transformation you used in informatica
How can we store previous session logs?
What do you mean by enterprise data warehousing?
Define Pmrep command?
What is union transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
