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

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2320


How would you determine what sessions are connected and what resources they are waiting for?

2127


Difference between transaction type and transaction sources. : oracle accounts receivable

1032


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

1265


What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1393


WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2113


A scenario for amount correction & how to use amount correction functionality in AP invoices

2134


i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.

2313


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

2010


as a technical developer in oracle applications which type errors feced in your experience sofar

2332


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

2231


as a technical developer in oracle applications which type errors feced in your experience sofar

2183


Explain how to close periods in ar. : oracle accounts receivable

1313


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7675


how to write customizations in po

1618