Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 16566 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / vsandhyana
select top 1 * from (select top 5 * from customers order by
salary desc) a order by salary asc
Thanks
Vikram Sandhyana
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How do we drill through from a powerplay cube to reportnet?\
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What are the services provided in cognos 8?
Explain what is the main advantage of impromptu over cognos reportnet?
Define query items?
What is the use of Cognos scenario?
Write some methods to apply securities in framework manager model?
Can you define drill across?
where you can save the report net documentation in our local system?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
How can we Maintain the Cube Security by Category level and Dimension level ?
Which studio is used to create reports?
what is the role of cognos comsultant?what actually it means?pls reply
Define the slice and dice?
What is a dimension?
