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

what are integrity rules?

1090


Can you sum a count in sql?

1059


Is it possible to include an insert statement on the same table to which the trigger is assigned?

1061


What is execution plan in sql?

1089


What is data modelling in sql?

1071


What are different types of queries in sql?

1170


Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1208


what is the difference between truncate and delete statement? : Transact sql

1116


What is autocommit sql?

1040


What are sql indexes?

1045


Why having clause is used in sql?

1019


What are primary key and foreign key and how they work?

1015


Can we join two tables without common column?

1057


Can we use pl sql in sql server?

1131


What is cursor explain with example?

1026