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 is fmtonly in sql?

1161


How many types of functions are there in sql?

1007


What is structural independence and why is it important?

1074


What are system versioned tables?

1074


what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

1019


What is the purpose of the primary key?

1117


How to use sql*plus built-in timers?

1263


Sql technical questions

1334


what does it mean to have quoted_identifier on? : Sql dba

1181


What are pl/sql cursor exceptions?

1167


Which is faster joins or subqueries?

1037


what are local and global variables and their differences? : Sql dba

1136


What is a temp table?

1073


how do you control the max size of a heap table? : Sql dba

1025


How can I change database name in sql?

1157