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
- 20606 Views
- HCL, I also Faced
- E-Mail Answers
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
What is the difference between drill through, drill across?
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 do you mean by query studio?
Can you explain cognos planning?
Can you define bitmap index?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What is a Pivot?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What are all the types of gateway used in Cognos?
Explain what is the main advantage of impromptu over cognos reportnet?
3. The vice president of sales has requested a graphical display of the same information provided in our last crosstab report (whatever I mentioned in above question) for an up coming presentation. We need to provide a chart report that shows which regions generate the most revenue and sales volume.
Give the advantages of cognos?
how you migrate reports to cognos 8 from previous versions?
4. How many dimensions did you use in your reports?
What are the types of hierarchies?
