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 find the n'th highest salary from emp ?

Answer Posted / brajesh kumar

SELECT *FROM EMP WHERE SAL=(SELECT MAX(SAL) FROM EMP)

Is This Answer Correct ?    5 Yes 25 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1885


what is difference between sql plus and sql*plus? (not sql and sql plus).

3810


Is java required for oracle client?

921


How to write a query with an inner join in oracle?

972


Difference between oracle's plus (+) notation and ansi join notation?

1027


What is the quickest way to fetch the data from a table?

999


What are the major difference between truncate and delete?

975


How to rename a column in an existing table?

970


Explain the difference between a procedure and a function?

1082


How to convert times to characters in oracle?

976


Explain a private synonyms?

980


What is the database name in oracle?

967


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2123


What is a subquery in oracle?

1038


Name the three major set of files on disk that compose a database in Oracle?

1062