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

hi iam looking for HRMS(functional) training inst or person in hyderbad. plz help me its urgent

Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

how to display last 5 letters from a name (take emp table ename )

How would you determine the time zone under which a database was operating?

How would you go about generating an EXPLAIN plan?

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Can We Restore a Table that accidantly dropped.

what are basic modules required to implement oracle application in any oraganisation?

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?

i want to know about the javaBean.what is its purpose and how it can use in Forms.

What is the Query Optimizer. How you optimize your qeury.

For more Oracle AllOther Interview Questions Click Here