Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to do Performence Tunning in Cognos Reports?

2444


what is the difference between native sql and cognos sql?

973


how to test reports in cognos?

989


Can you define a datastore in cognos?

1001


What are slice and dice?

897


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.

2476


Can you define metrics designer?

1032


Which studio is used to create reports?

1084


What is called cognos reporting tool?

1019


i have one file i saved in csv how can i take these file into framework manager

2061


Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

2027


how you create security to reports?

1031


What are the advantages of using cognos sql?

1157


-------------What is Coditional Prompting?

2109


How the Bursting happens in same report and how to Print the bursting Report?

1830