select emp_salary from emp e where 3 =(select count(distinct emp

find the 3rd max salary

Question Posted / udaya

Answer Posted / udaya

select emp_salary from emp e where 3 =(select count(distinct
emp_salary) from emp where e.emp_salary<=emp_salary)

Is This Answer Correct ?

11 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

996

What samples and sample databases are provided by microsoft?

1022

How do you Implement SSIS Packages in your Project?

1904

What are the common performance issues in sql server?

897

How to recreate an existing index in ms sql server?

1030

What is the full meaning of dml?

934

What are sql server procedures?

957

What are the advantages dts has over bcp?

974

Explain the ways to controlling cursor behavior?

901

How do I create a trace in sql server?

1007

How do you rename a table in sql server?

1001

How to create a scrollable cursor with the scroll option?

977

List the different types of joins?

965

Can I work with several databases simultaneously? : sql server management studio

968

What is the difference between functions and stored procedures?

1134