Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / pradeep nagireddy
select *
from(select rownum r,sal from emp order by sal desc)
where rownum = 5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
how to merge 2 crosstabs thans
Can you define materialized view?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
Please explain the different stages in creating a report in cognos report net?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What are the components of report net?
Define datastores in cognos?
Can you define framework manager?
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 zero-foot print?
What do you mean by drill through report?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
Give me any example of semi and non additive measures?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder