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
What is a dimension?
Can you define drill across?
How to create a cube in Transformer? What is the process? Please mention process thank u
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
------------------What is Inline Query?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
What is Metrics designer?
What is a Pivot?
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?
Define cognos report net?
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.
Can you explain dynamic query mode?
What is cognos reporting tool?
What is the report studio?
What is the use of Cognos scenario?