Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17527 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / srcreddy
select* from
(select rownum rank,ename,sal from emp order by sal desc) where rank=5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by Drill down and Drill Up?
What are all types of Batches?
What is drill down and slicing and dicing whats the difference between them?
What are the considerations regarding performance kept in mind while setting up cognos?
write a query to display the departments with no employee?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
How to create a cube in Transformer? What is the process? Please mention process thank u
Why cognos decision stream is used?
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 are the message flows?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com
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
How can you link a query to a data container manually in Report Studio?
Explain what is the difference between microstrategy and cognos reporting tool?
What is the model filter?
