Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17529 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 cognos powerhouse?
What is Additive function?
What errors and types of errors you faced in Cognos ReportNet?
how to connect datamarts
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What are the methods by which it non-durable model could be changed into the durable model?
----------------Diff b/w Dimensional modeling and Relational modeling?
How security is concerned with Reportnet? Explain its implementing steps.
What is meant by alternate drill down with ex?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
What are the steps to import the two data sources in framework manager?
How the Bursting happens in same report and how to Print the bursting Report?
How to do Performence Tunning in Cognos Reports?
hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com
-----------Diff b/w OLAP and RDBMS?
