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 / naresh

Select * From TableName T1 Where
(N-1) = (Select Count(Distinct(E2.ColumnName))
From TableName T2 Where T2.ColumnName > T1.ColumnName)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

1416


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

2179


which one is currently in used software cmpanies.

2200


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

2494


What is auto invoicing? Explain : oracle accounts receivable

1171


What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?

1207


Explain about party and customer in ar : oracle accounts receivable

1272


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.

2385


What do you mean by hz_ in customer tables? : oracle accounts receivable

1301


i want to know about the javaBean.what is its purpose and how it can use in Forms.

2513


Difference between negative and positive adjustments : oracle accounts receivable

1163


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.

3999


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2283


difference of using cursor for loop and open,fetch,close.which one is better

1866


What is the use of lockboxes? : oracle accounts receivable

1263