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
- 21442 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / rakesh
select rownum as rank,name,sal
from
( select name,sal from employees order by sal desc)
where
rownum=5
| Is This Answer Correct ? | 3 Yes | 7 No |
Post New Answer View All Answers
What is Metrics designer?
Can you explain a cognos controller?
Can you define a datastore in cognos?
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!
faq's on cognos
What are initial page components of Cognos connection?
What are the different types of reports present in cognos?
Can you define cognos impromptu?
What are the types of security?
What is an olap designer?
Explain is there any comparison available for cognos reportnet vs crystal reports?
What do you understand by the term 'aggregate cache'?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
What are the methods by which it non-durable model could be changed into the durable model?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
