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 DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

Is This Answer Correct ?    15 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is proxy method?

925


What is recycle bin in Oracle?

1084


hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2195


What is the difference between Delete, Truncate and Drop in Oracle?

1062


How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1870


How to set a transaction to be read only in oracle?

1028


What is index in Oracle?

1005


How can we create the complete backup of data in the oracle.

2087


Explain mutating triggers.

969


What is user managed backup in Oracle?

1072


Explain the difference between sap and oracle?

971


How to export data with a field delimiter?

969


What is query image?

921


What is a trace file and how is it created in oracle?

970


Is it possible to insert comments into sql statements return in the data model editor ?

2507