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

select salary from (select salary from table order by salary
desc) v where rownum<=100

Is This Answer Correct ?    8 Yes 19 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

List and explain the different types of join clauses supported in ansi-standard sql?

1301


Is grant a ddl statement?

855


Why is sql*loader direct path so fast?

1054


What are the two types of periodical indexes?

886


What are user defined functions?

951


What is java sql connection?

967


Can I join the same table twice?

996


How do you declare a variable in pl sql?

967


What is cursor in pl sql with examples?

954


How do I save a sql query?

962


How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

1035


What is the purpose of cursors in pl/sql?

1081


What is trigger types of trigger?

996


what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

997


Which is faster truncate or drop?

983