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

select salary from (select salary from sample where
rownum<11 order by salary desc) where rownum<2

Is This Answer Correct ?    3 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is truncate ddl or dml?

945


How to select 10 records from a table?

1099


What is sql catalog?

964


Why having clause is used in sql?

931


Define a temp table?

966


What is the difference between partition and index?

926


What is update query?

922


The in operator may be used if you know the exact value you want to return for at least one of the columns.

1028


how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

918


what is a trigger in mysql? Define different types of trigger. : Sql dba

1012


Why join is faster than subquery?

1048


What is number function in sql?

915


What is on delete set null?

1039


What is use of term?

1008


How to run pl/sql statements in sql*plus?

1023