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
- 20551 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
select * from emp e where 5=(select count(distinct sal)
from emp e where e.sal<=sal)
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
what is online view?
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.
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
Diff b/w Crossproduct and Outerjoin?
How do you call a store procedure within a transformation?
what are the errors faced while bursting the reports and how to solve those errors?
Explain what is the difference between native sql and cognos sql?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What are all the types of hierarchies?
---------------Describe OLAP Reporting and RDBMS Reporting?
What do you understand by the cognos?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What do you understand by ‘ibm predictive maintenance and quality’?
What is drill down and slicing and dicing whats the difference between them?
