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
- 20421 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / balanandam
select * from emp where sal =(select sal from(select sal,rank() over(order by sal desc) sal_rank from emp group by sal) where sal_rank=&rank)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What errors and types of errors you faced in Cognos ReportNet?
Define the cognos reporting tool?
what is power prompt in cognos ep7series?what is the use of this?
What is an olap designer?
how to perform single sign in cognos by using url?
What do you understand by the term 'dynamic cube'?
How can I test reports in cagonos?
What are the advantages of using cognos sql?
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
How to join multiple db in catalog?
what is log in cognos?
What is a Cube?
What is main advantage datawarehousing over oracle?
what is a prompt value in report studio and variables ?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
