Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
- 14 Answers
- 17536 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 is Inline Query?
Can you explain dynamic query mode?
Can we test the report other than manual testing?
How to do Performence Tunning in Cognos Reports?
What are the different kinds of panes included in cognos?
--------------Diff b/w ODS and OLAP?
How to a create header dynamically in a crosstab report in cognos 8.1?
What is difference between informatica power mart and power center?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
how to perform back drill through in cognos 8 what is the use of it
What is the use of report studio?
Can you explain a cognos controller?
what are all the versions of cognos and cognos8 as well as mention all the advantages nd disadvantages in cognos8 versions. any one plz answer this question.
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What is defined as catalog and types of catalogs in Cognos?
