select ename, salary from emp where salary=(select top 1 salary from (sel

Find out the 3rd highest salary?

Question Posted / virendra

Answer Posted / virendra

select ename, salary from emp where salary=(select top 1
salary from (select distinct top 3 salary from emp order
by salary desc) a order by salary)

Is This Answer Correct ?

7 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is dba in sql? : SQL DBA

1009

Is sql a scripting language?

946

How to test for null values?

1002

What is sharding in sql?

937

How do sql triggers work?

1002

How can I get the number of records affected by a stored procedure?

1025

What is the difference between partitioning and sharding?

974

What is the use of stored procedures?

997

What are database links used for?

1012

What types of commands can be executed in sql*plus?

1075

What is a left inner join?

970

What is cursor and why it is required?

1132

Can we call stored procedure in function?

920

how to escape special characters in sql statements? : Sql dba

996

What is sql used for?

1082