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

Does a user_objects view have an entry for a trigger?

1050


What is the need of a partition key?

1029


What is a delimiter in sas?

1127


what is 'mysqld'? : Sql dba

1017


Why trigger is used in sql?

1016


What is a recursive stored procedure?

1253


what is primary key? : Sql dba

1081


Can we create table inside stored procedure?

1014


What is the difference between left outer join and left join?

1037


What are tables and fields?

1087


Does google use sql?

1007


What is the difference between execution of triggers and stored procedures?

1156


How to Execute a Package in PL/SQL.?

1286


What is a parameter query?

1143


what is error ora-03113: end-of-file on communication channel?

1226