Interested to Buy Any Domain ? << Click Here >> for more details...
Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 20916 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / vsandhyana
Hi Hashmatulla Baig,
I think your query will not give the desired output. it
should be modify please refer below for the same.
SELECT empno, sal
FROM
(
select empno, sal, (ROW_number() OVER (order by sal desc)) R
from emp
order by sal desc
)
WHERE R = 5;
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Can you define a query subject?
What is called materialized view?
What is looping and how to avoid it in framework manager?
What are the advantages of using cognos sql?
Can we test the report other than manual testing?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
Write some methods to apply securities in framework manager model?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
How Metrics Studio is better than Report Studio?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What is set to be Cognos configuration?
what are the special features in cognos reportnet?
Define the cognos reporting tool?
Can you define drill down and drill up?
