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
- 20920 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / pradeep nagireddy
select *
from(select rownum r,sal from emp order by sal desc)
where rownum = 5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the batches and it’s details?
What do you understand by the term 'dynamic cube'?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
what are the filters in framework manager and report studio?
How to test a cube?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What is set to be Cognos configuration?
New coloums are added in database, then how you know in report level
What is the enterprise class platform architecture of cognos 8?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
What is model filter?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What is called a slice?
what is model and say about process how to create model and how to test model?
How to Reset Pagenumbers in one report.
