Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
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
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
is there any difference between operational database and data base?if yes what r they?
Can you define cube?
How is cognos model organization works?
how to create measures and dimensions?
What is the use of powerplay web viewer in cognos?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
How to Reset Pagenumbers in one report.
What junk dimension contains?
Explain the characteristics of cognos?
How Metrics Studio is better than Report Studio?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
What is Fullouterjoin?
We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?
Define catalog in cognos and write its various types?