Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
Answer Posted / srcreddy
select* from
(select rownum rank,ename,sal from emp order by sal desc) where rank=5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between the content store and content manager?
What is the difference between low affinity and high affinity connections?
What is a Framework manager?
What is main difference mapplets and mapping?
Explain the difference between powerplay transformer and power play reports?
What is defined as data mining?
Which lifecycle we will use for reporting?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
is cognos 7 is better than cognos 8
What do you understand by the term 'model durability'?
What are all the types of indexes in Cognos?
What is set to be Cognos configuration?
What r the names of the reports that you prepared?
What are the advantages of shortcuts?
7. What is performance tuning?