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 are the datatypes available in pl/sql ?

1045


Explain what is a field in a database and record in a database?

1016


What is indexing oracle sql?

1026


what is the difference between where clause and having clause? : Sql dba

950


what is an alias command? : Sql dba

1011


What is t sql used for?

974


what are ddl statements in mysql? : Sql dba

1114


Is primary key a clustered index?

914


Does a user_objects view have an entry for a trigger?

963


What is exception? What are the types of exceptions?

1034


What is program debugging?

1134


Enlist the advantages of sql.

939


Does mysql support pl sql?

1099


What is dense_rank in sql?

917


Is it possible to update views?

919