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 / goutham4mail@gmail.com

select top 1 * from Emp where Sal in
(select top 100 Sal from Emp order by Sal desc) order by
Sal asc

Is This Answer Correct ?    3 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between microsoft sql and mysql?

967


What are records give examples?

1014


Define sql delete statement.

1016


What does count (*) mean?

936


What are the two types of cursors in pl sql?

1085


What is pl sql block structure?

1044


What are types of exception?

923


what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

1079


Is stored procedure faster than query?

972


What is the difference between alter trigger and drop trigger statements?

1116


What are the usages of sql?

1060


What do you know by pl/sql cursors?

1110


What is the largest value that can be stored in a byte data field?

1017


What is the difference between union and union all command?

1096


discuss about myisam key cache. : Sql dba

1024