Interested to Buy Any Domain ? << Click Here >> for more details...
What is the sql query to find the employee who has Nth
maximum salary?
- 2 Answers
- 5218 Views
- I also Faced
- E-Mail Answers
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 do you mean by hz_ in customer tables? : oracle accounts receivable
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is Restricted Mode of Instance Startup in Oracle?
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What is chargeback invoice? How do we create it? : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
what is difference between inner join & nested query or subqueries
How would you determine who has added a row to a table?
What is the disk migration? what is the steps involved in oracle disk migration?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What is Tax Categories?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
What is the mandatory setup in cyclecount ?
Difference between transaction type and transaction sources. : oracle accounts receivable
