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 difference between db2 and sql?

997


Explain normalization and what are the advantages of it?

951


What is a database event trigger?

1159


Does pdo prevent sql injection?

931


What are system versioned tables?

1024


What is a dynamic query?

1020


What is application trigger?

994


What is recursive stored procedure?

1099


What is procedure and function in sql?

997


Can there be more than one function with a similar name in a pl/sql block?

980


What is the purpose of cursors in pl/sql?

1134


Why do you partition data?

1016


What are different joins used in sql?

1055


Is it possible to create the following trigger: before or after update trigger for each row?

1284


What is difference between sql function and stored procedure?

1002