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 sub-query? : Transact sql

1078


What is fmtonly in sql?

1057


What is record data type?

897


What are the different schemas objects that can be created using pl/sql?

999


What is schema in sql?

924


what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba

1021


Do we need commit after truncate?

1062


What are types of joins?

946


What is cursor and its types?

1045


What is sql indexing?

997


How do you bind variables in pl sql?

1072


What is $$ in sql?

970


What is an oracle stored procedure?

1028


What are expressions?

989


How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

1118