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
Are These Dff's Flexible?
1. What is PO rate variance gain and loss?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
What are different types of receipt reversals ? Explain them : oracle accounts receivable
How do you create a credit note against an invoice? : oracle accounts receivable
How would you determine who has added a row to a table?
where the dff data will be stored
Explain how to close periods in ar. : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
what are the tools used for oracle 10g in real time.
Difference between negative and positive adjustments : oracle accounts receivable
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.
Explain prerequisites and post activities of oracle database installation
Differentiate between transaction type and transaction source? : oracle accounts receivable
how to write customizations in po