Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 16582 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 the use of backward drilling in cognos 8?is it possible?whats the uws of it?
How can I test reports in cagonos?
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
Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin
What is the difference between regular dimension and derminant?
What is a Transformer?
Name the types of report?
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What is a Framework manager?
Can you define a datastore in cognos?
How create measures and dimensions?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What is a Folder?
What is dtm?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
