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
- 21415 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / dramesh511
select sal from emp e where 5=(select count(sal) from
emp e1 where e.sal<=e1.sal)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
-----------Diff b/w OLAP and RDBMS?
What are all the advantages of Cognos?
What is looping and how to avoid it in framework manager?
What is meant by alternate drill down with ex?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
How to select multiple values from type-in prompt?
5. Which type of report you build more, list, crosstab or chart and why?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
What is the difference between set functions and filter function in dimensional data?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
-----------------What is Determination Model?
hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file
Can you define cognos powerplay?
Why cognos decision stream is used?
