yah this query works fine and return the 2nd highest salary.

Following are some of the question related to below
mentioned query?

select e1.salary from employee3 e1
where 2=
(
select count(distinct(e2.salary))
from employee3 e2 where e2.salary>=e1.salary
)

1) What the query returns?

2) How it works? - Detail explanation (what the sub query
does, why it is (where 2=)....etc...Please?

Question Posted / haris

5 Answers
7758 Views
I also Faced
E-Mail Answers

Answer Posted / haris

yah this query works fine and return the 2nd highest salary.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does partitioning improve performance sql server?

952

Which sql server table is used to hold the stored procedure script?

927

What is PROJECTION Operation?

1004

What are the pre-defined functions in the sql server?

1080

What is a field name?

945

What are binary string data types in ms sql server?

1253

Can we join two tables without primary key?

1019

What are diverse clauses that form a part of sql?

1052

What is instead of trigger sql server?

980

Comment,Datatypes are unlimited

2048

How to throw custom exception in Stored Procedure?

1023

What are cascading parameters in ssrs reports?

228

What do you mean by a dependent functionality in a build?

1114

Explain the creation and execution of a user-defined function in the sql server?

1030

What is the use of set nocount on/off statement?

1074