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

find the third highest salary?

Answer Posted / srinath reddy

select * from emp e1 where 3 = (select count(*) from emp e2
where e1.salary <= e2.salary);

instead of answer we can say this as a solution where we can
find nth also

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you know if a relationship is 2nf?

877


What are triggers in sql?

972


What is sql procedures and functions?

955


What is compute?

1011


Is it possible to create startup or shutdown trigger for on-schema?

979


What is a full join sql?

981


Explain what is rdbms?

991


What is lexical units in pl sql?

1052


Why do we go for stored procedures?

994


What are the different sql commands?

1001


What is the purpose of design view?

950


What is sql character function?

994


Write a query to find the names of users that begin with "um" in sql?

924


how to enter characters as hex numbers? : Sql dba

993


What is percent sign in sql?

1213