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
- 20587 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
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
is cognos 7 is better than cognos 8
What is the advantage of using shortcuts?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
Explain is there any comparison available for cognos reportnet vs crystal reports?
How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?
What is an olap designer?
What errors and types of errors you faced in Cognos ReportNet?
What is Bitmap Index?
What is main difference mapplets and mapping?
how to test reports in cognos?
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
What is difference between primary key and unique key constraints?
Can you define drill across?
