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

select top(100) salary from table1 where salary not
in(select top(99) salary from table1)

Is This Answer Correct ?    1 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by field in sql?

1037


how to increment dates by 1 in mysql? : Sql dba

928


Is crud a cuss word?

975


What is dml and ddl?

902


what is foreign key? : Sql dba

972


Are dml statements autocommit?

987


What is primary key and foreign key with example?

876


What are different methods to trace the pl/sql code?

1050


What are the events on which a database trigger can be based?

1103


What is cursor status?

1135


What are records give examples?

954


What is rownum in sql?

967


What is index example?

954


What is the difference between the conventional and direct path loads? : aql loader

1318


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

918