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...

What is the sql query to find the employee who has Nth
maximum salary?

Answer Posted / naweed ahmad

SELECT * FROM Emp E1 WHERE n-1 =
(SELECT COUNT(DISTINCT Sal) FROM Emp E2 WHERE E1.Sal <
E2.Sal)order by Sal desc

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

2213


Give two methods you could use to determine what DDL changes have been made.

6747


HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2493


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2352


i am working with OC 4.5 i have numbers in table in 10 row with some null values please tell me how to find total? Thanks

2249


how to write customizations in po

1599


Can we modify approve purchase order?if yes what is navigation?

1996


Why more redos are generated when the oracle database is in begin backup mode?

1104


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2257


what are the tools used for oracle 10g in real time.

2423


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

1258


What is the importance of batch source set up in ar? : oracle accounts receivable

1238


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2201


Explain about party and customer in ar : oracle accounts receivable

1188


3. Steps in UAT?

2410