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

select salary from employee e
where 100=(select count distinct salary) from employee where
e.salary<=salary

Is This Answer Correct ?    3 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is 'mysqldump'? : Sql dba

1115


What is group by in sql?

1090


What is sql basics?

1047


Explain lock escalation? : Transact sql

1210


How does sql*loader handles newline characters in a record? : aql loader

1054


What is trigger with example?

1106


Can we join tables without foreign key?

968


How does join work in sql?

1021


What does (+) mean in sql joins?

1074


what tools available for managing mysql server? : Sql dba

1090


Which normal form is best?

954


How do I copy a table in sql?

997


What is the reports view in oracle sql developer?

999


Why self join is used in sql?

986


What is primary key and foreign key?

967