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
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
which one is currently in used software cmpanies.
what are the tools used for oracle 10g in real time.
What is auto invoicing? Explain : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Explain about party and customer in ar : oracle accounts receivable
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.
What do you mean by hz_ in customer tables? : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
Difference between negative and positive adjustments : oracle accounts receivable
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.
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
difference of using cursor for loop and open,fetch,close.which one is better
What is the use of lockboxes? : oracle accounts receivable