First of all this query doesn't execute. I tried it on SQL 2005 and k

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 / chintan

5 Answers
7819 Views
I also Faced
E-Mail Answers

Answer Posted / chintan

First of all this query doesn't execute. I tried it on SQL
2005 and kept getting error.

Is This Answer Correct ?

0 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a primary index?

924

What are statistics?

999

What is ms sql server reporting services?

1055

How to list all user names in a database?

1058

Is it possible for a stored procedure to call itself or recursive stored procedure?

952

If a stored procedure is taking a table data type, how it looks?

6449

How is foreign key related to primary key?

970

How do we Backup SQL Azure Data?

108

Difference between 2NF &3NF ?

1084

What is the difference between web edition and business edition?

111

How to defragment indexes with alter index ... Reorganize?

1088

Equi join and non equi join is possible with sql server?

1022

What is a functions and types in sql server?

1087

What is failover clustering overview?

1089

Can you pass expressions to function parameters?

1103