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

How do you create a credit note against an invoice? : oracle accounts receivable

1028


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

1022


what are the API of GL,PO,AP

2217


What is mrc and what is its use? : oracle accounts receivable

1101


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2277


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

1065


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

7571


Explain the use of table functions.

2382


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2013


What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.

3867


Is there any link between pr form(purchse requisition)and po form(purchase order)

2649


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

1009


What is auto invoicing? Explain : oracle accounts receivable

1056


What is Tax Categories?

2050


what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2168