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

SELECT LEVEL, MAX(Sal)
FROM Emp
GROUP BY LEVEL
HAVING LEVEL = &GiveNo
CONNECT BY PRIOR Sal > Sal;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you explain an index number?

1110


Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1025


what is timestamp in mysql? : Sql dba

1078


what is 'mysqld'? : Sql dba

971


What is java sql driver?

1125


What is data modelling in sql?

1020


Is sql harder than python?

1109


what is rollback? : Sql dba

1112


what is auto increment? : Sql dba

1011


Name the operator which is used in the query for pattern matching?

955


How is a PL/SQL code compiled?

1236


What trigger means?

986


what is the difference between undefined value and null value? : Sql dba

1102


Explain the rollback statement?

1013


what are properties of a transaction? : Sql dba

1094