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
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.
What is the use of lockboxes? : oracle accounts receivable
8. Supporting AP, AR and GL?
What is the mandatory setup in cyclecount ?
What is auto invoicing? Explain : oracle accounts receivable
key flexfield structure
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
What is an Oracle database Partial Backup?
What is the difference between recovery and restoring of the oracle database?
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
as a technical developer in oracle applications which type errors feced in your experience sofar
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
What is the sql query to find the employee who has Nth maximum salary?