Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?
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
How to do Performence Tunning in Cognos Reports?
what is the difference between native sql and cognos sql?
how to test reports in cognos?
Can you define a datastore in cognos?
What are slice and dice?
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.
Can you define metrics designer?
Which studio is used to create reports?
What is called cognos reporting tool?
i have one file i saved in csv how can i take these file into framework manager
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
how you create security to reports?
What are the advantages of using cognos sql?
-------------What is Coditional Prompting?
How the Bursting happens in same report and how to Print the bursting Report?