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

how to findout the 100th maximum salary

Answer Posted / ram

select * from emp
where sal in(select max(sal) from emp
where level=&nth
connect by prior sal>sal
group by level)order by sal

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql trigger example?

998


What are functions in sql?

900


What are all ddl commands?

1014


What is the difference between numeric and autonumber?

939


Why do we use partitions in sql?

976


Do ddl statements need commit?

922


What are conditional predicates?

987


explain what is mysql? : Sql dba

1031


What is cte?

923


How you improve the performance of sql*loader? : aql loader

955


can a stored procedure call itself or recursive stored procedure? : Sql dba

956


What is sql stand for?

945


Can you load data into multiple tables at once? : aql loader

1021


What are the steps for performance tuning.

1268


what are the differences between char and varchar? : Sql dba

1002