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

select sal from emp e
where 100=(select count( distinct sal) from emp where
e.sal<=sal)

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why we use triggers in mysql?

990


Write the alter statement to enable all the triggers on the t.students table.

1123


What is sql table?

962


what are the differences between require and include, include_once and require_once? : Sql dba

1018


how would you enter characters as hex numbers? : Sql dba

981


Does sql profiler affect performance?

987


Is merge a dml statement?

973


What are inner and outer joins examples of both?

952


What do you mean by field in sql?

1075


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

966


Can we create index on primary key?

961


Do ddl statements need commit?

961


Is it important to partition hard disk?

1022


How do I find duplicates in sql?

929


How do I run a sql query?

1012