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

What is Restricted Mode of Instance Startup in Oracle?

how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)

Explain materialized views and how they are used.

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

What is difference b/w Credit memo and Adjustment in AR.

What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

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

hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me

can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

how can it possibble to see the report output in excel sheet in oracle applications

Differentiate between transaction type and transaction source? : oracle accounts receivable

For more Oracle AllOther Interview Questions Click Here