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 / soumya

select * from (select rownum, salary from emp order by
salary ) where rownum=100;

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of normalization?

1040


What is the difference between alter trigger and drop trigger statements?

1103


What is the best sql course?

979


what are the properties and different types of sub-queries? : Sql dba

1032


What are the advantages of pl sql over sql?

1025


Can we use rowid as primary key?

985


Can one improve the performance of sql*loader? : aql loader

1046


what are wild cards used in database for pattern matching ? : Sql dba

1138


Which command is used to delete a package?

1165


what is msql? : Sql dba

988


Does varchar need length?

991


What is an escape character in sql?

1024


What is the difference between union and union all command?

1088


Which sql statement is used to return only different values?

1003


What are the different sql languages?

1035