Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / dramesh511
select sal from emp e where 5=(select count(sal) from
emp e1 where e.sal<=e1.sal)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are all the different types of prompt in cognos?
what is a prompt value in report studio and variables ?
What is looping and how to avoid it in framework manager?
What r the names of the reports that you prepared?
How to create model and how to test model?
What are the services provided in cognos 8?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is a Transformer?
Define metrics studio?
What are the different types of important services used in cognos?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
What is the difference between Open Connection command ang Open Session Command?
What are the ways to import data into catalog?
What are various types of gateways in cognos?
What is a Datastore in Cognos?