Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / hashmatulla baig
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 ? | 3 Yes | 2 No |
Post New Answer View All Answers
how you provide security to reports? How you provide security to packages ?
What are the ways to import data into catalog?
What are the services provided in cognos 8?
How do you call a store procedure within a transformation?
i have one file i saved in csv how can i take these file into framework manager
What is difference between informatica power mart and power center?
Explain the characteristics of cognos?
What is the difference between set functions and filter function in dimensional data?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
What is zero-foot print?
What is Bitmap Index?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is a Pivot?
What is the metric store database?
whats the difference between previous version of cognos and cognos 8 BI?