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

What is rownum?

983


what are the differences between require and include, include_once and require_once? : Sql dba

1023


Why we use pl sql?

962


What is index example?

1010


What are the advantages of sql?

1055


What is sqlcommand?

1032


What is character functions?

1061


what is the command line end user interface - mysql? : Sql dba

981


How to place comments in pl/sql?

1159


How to select unique records from a table?

1059


Mention what pl/sql package consists of?

998


Is a secondary key the same as a foreign key?

1038


What is delimiter in pl sql?

1062


Explain what is an index?

1057


Is there a way to automate sql execution from the command-line, batch job or shell script?

972