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?
Where in the Oracle directory tree structure are audit traces placed?
HOW TO SPOT AHIERARCHY?
Explain the use of table functions.
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
how to write customizations in po
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5
Explain the process of recievables in oracle financials. : oracle accounts receivable
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
can we use lexical perameter in oracle plsql if yes how
What is the difference between conversions and interfaces? : oracle accounts receivable
What is the importance of batch source set up in ar? : oracle accounts receivable
what are the API of GL,PO,AP
How do you create a credit note against an invoice? : oracle accounts receivable
as a technical developer in oracle applications which type errors feced in your experience sofar