select * from employee.e1 where (n-1) = ( select (distinct b.salary ) from

how to find nth highest salary

Question Posted / ravikiran

Answer Posted / ravikiran

select * from employee.e1 where (n-1) =
( select (distinct b.salary ) from employee.e2 where e1.salary > e2.salary

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is role playing dimension with two examples? : sql server analysis services, ssas

603

How many types of attribute relationships are there? : sql server analysis services, ssas

596

What is #temp and @table variable in SQL server?

599

How can sql server instances be hidden?

532

How to get a list of columns using the "sys.columns" view in ms sql server?

576

What is the Disadvantage of indexed sequential file.

634

Why do we partition data?

626

Tell about MOM Tool(Microsoft Operator Manager)?

1426

What are the underflow and overflow behaviors on float literals?

598

How to loop through result set objects using mssql_fetch_array()?

553

How to test values returned by a subquery with the in operator?

688

How many non clustered indexes there can be on table ?

518

Why are you getting errors when creating a new odbc dsn?

610

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

558

What is a trigger and its types?

551