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
- 20969 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 the use of cognos decision stream?
where you can save the report net documentation in our local system?
what is the difference between native sql and cognos sql?
Can you define a catalog and types of catalogs in cognos?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What are slice and dice?
What is model?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
how to create measures and dimensions?
-----------------What is Determination Model?
How create measures and demensions?
Can you define cognos decision stream?
explain how to create powerplay reports?
How to create a cube in Transformer? What is the process? Please mention process thank u
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
