Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17530 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
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
2. What functional area you worked on.
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What you mean by drill across and what is the difference between drill through, drill across?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
how to explain health care project and which reports we can create in health care doain?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
How we check the errors before running the report?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
Can you define a query subject?
What is meant by alternate drill down with ex?
i was asked what are the caluclations done by you in your report? plz give reply
What are the batches and it’s details?
