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 / akki reddy

SELECT *
(SELECT SAL, ROWNUM RN FROM EMP ORDER BY SAL DESC)
WHERE RN=100;

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do we need to check in database testing?

1017


How to combine two stored procedures in sql?

1226


Show code of a cursor for loop.

1052


What is execution plan in sql?

1041


What is forward declaration in pl sql?

1077


Why do we go for stored procedures?

1055


what are numeric data types? : Sql dba

1060


Is like operator in sql case sensitive?

1021


why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

1106


Is it important to partition hard disk?

1022


What is dense_rank in sql?

984


Is json a nosql?

979


What are the different types of database management systems?

999


Which data type is a composite type?

988


Why do we use joins?

1033