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

Explain the savepoint statement.

1137


what is the difference between char and varchar data types? : Sql dba

1174


Why do we use cursors?

1044


Explain mutating table error.

1261


How can we find duplicate records in a table?

992


what is bdb (berkeleydb)? : Sql dba

1093


What is user defined functions?

1028


Is left join faster than join?

1096


What are different types of triggers?

1181


What is the maximum rows in csv?

977


explain about mysql and its features. : Sql dba

1053


What is the difference between a primary key and a unique key?

1108


What is sql and also describe types of sql statements?

1114


What is cursor explain with example?

1031


Why do we use procedures?

1007