What is the sql query to find the employee who has Nth maximum salary?

What is the sql query to find the employee who has Nth
maximum salary?

Question Posted / rajini

Answers were Sorted based on User's Feedback

What is the sql query to find the employee who has Nth maximum salary?..

Answer / 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

What is the sql query to find the employee who has Nth maximum salary?..

Answer / naweed ahmad

SELECT * FROM Emp E1 WHERE n-1 =
(SELECT COUNT(DISTINCT Sal) FROM Emp E2 WHERE E1.Sal <
E2.Sal)order by Sal desc

Is This Answer Correct ?

0 Yes

0 No

More Oracle AllOther Interview Questions

please send me oracle pl/sql exp resume. and also faqs...

What do you mean by hz_ in customer tables? : oracle accounts receivable

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

Name two files used for network connection to a database.

What is mrc and what is its use? : oracle accounts receivable

HOW TO SPOT AHIERARCHY?

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

Explain prerequisites and post activities of oracle database installation

What command would you use to create a backup control file?

Give the reasoning behind using an index.

Difference between transaction type and transaction sources. : oracle accounts receivable

What is the difference between oracle media recovery and crash recovery?

For more Oracle AllOther Interview Questions Click Here