What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / sree
select sal from emp e where nth=(select count(*) from emp
where sal>e.sal);
Is This Answer Correct ? | 5 Yes | 12 No |
Post New Answer View All Answers
what is index?how it can work in informatica
What is union transformation in informatica?
Explain sessions. Explain how batches are used to combine executions?
What is pmcmd command?
Explain why we use partitioning the session in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
my source is junk data how will u remove that junk data by using unix please any one replay me
Define pmcmd command?
What do you understand by SOA of Informatica?
What are the different transaction levels available in transaction control transformation?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What do you mean by enterprise data warehousing?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the mapping parameters and mapping variables?
Performance tuning( what you did in performance tuning)