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

select salary from (select salary from sample where
rownum<11 order by salary desc) where rownum<2

Is This Answer Correct ?    3 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What type of join is sql join?

982


What is break?

1197


What are tuples in sql?

1135


How to run sql statements with oracle sql developer?

1068


Explain what is a subquery ?

1188


Why we use joins in sql?

982


What is cold data?

960


Is sqlite free?

971


Which is faster joins or subqueries?

991


Why is sql better than hql?

992


What is range partitioning?

965


What is trigger and stored procedure in sql?

1034


What are local and global variables and their differences?

1090


What are the types of queries in sql?

1086


What is the use of %rowtype?

1041