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...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

find out the third highest salary?

Question Posted / amrish singh

Answer Posted / amrish singh

this is the query for retrieving nth highest salary from
table emp
select e.sal
from emp e
where n-1=(select count(*) from emp s where s.sal>e.sal)

putting the value of n we get the required result.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can select statements be used on views in oracle?

982

How to create a new table in your schema?

1028

Are truncate and delete commands same? If so why?

1079

Why is oracle database so popular?

947

Explain table?

1060

What is hash cluster in oracle?

1087

How to assign values to variables?

1043

How to bring a tablespace online?

994

HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2432

Give the various exception types.

943

How to drop an existing view in oracle?

903

What are the general rules on data consistency?

957

Hi Can any one tell me what are the API's used in requisition import.

1879

Does facebook use oracle?

979

What is a sub query? Describe its types?

963