Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / balanandam
select * from emp where sal =(select sal from(select sal,rank() over(order by sal desc) sal_rank from emp group by sal) where sal_rank=&rank)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
hi friends pls forward impropmtu interview question
What do you understand by the term 'aggregate advisor?'
What is the difference b/w macros and prompt?
How to do Performence Tunning in Cognos Reports?
Can we test the report other than manual testing?
explain how to create powerplay reports?
7. What is performance tuning?
Can you explain model durability?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What is a Framework manager?
Explain what is the main advantage of impromptu over cognos reportnet?
How is cognos model organization works?
How can we create a dynamic column name in cognos?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
How to deploy from one server to another server?