What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / venky
select * from emp e where &n=(select count(distinct(b.sal))
from emp b where e.sal=b.sal);
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are ETL Tools?
In how many ways we can create ports?
What is xml source qualifier transformation in informatica?
Explain sql transformation in script mode examples in informatica
What is Session and Batches?
What is an unconnected transformation?
What is depict expression change?
What are the prerequisite tasks to achieve the session partition?
Clarify the aggregator change?
what is diff b/t sorter t/r and agg have the option sorter property...
What is meant by target load plan?
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 ?
What are Dimensional table?
how to load rows into fact table in data warehouse
What is incremental aggregation?