Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 16471 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / karthik murugeshan
SELECT B.Salary FROM (SELECT Salary FROM EMP)A,(SELECT
Salary FROM EMP)B
WHERE A.Salary>=B.Salary
GROUP BY B.Salary
HAVING COUNT(B.Salary)=5
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
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
Can you define cognos impromptu?
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
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.
Can you define query studio?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
What is the difference between a cascading report and drill through report?
Can we test the report other than manual testing?
Can you define transformer?
Explain is there any comparison available for cognos reportnet vs crystal reports?
can anyone provide link to download cognos 7.2 version for download along wiht installation and configuration steps tx in advance
how u will determine the performence tune will occur either in report or system
What is difference between informatica power mart and power center?
