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
7762 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 do you mean by an execution plan? How would you view it?

904

what authentication modes does sql server support? : Sql server database administration

1071

What is collation sensitivity?

1039

How do I create a trace in sql server?

1012

Do you know what are pages and extents? : SQL Server Architecture

980

Define ACID properties in a Database?

1045

What happens if time-only values are provided as date and time literals?

994

Explain the architecture of ms sql reporting service?

906

What does null mean?

971

What are filegroups in sql server?

1047

Explain filtered indexes benefits?

990

What is exclusive locks?

942

What is master database? : SQL Server Architecture

999

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1036

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1372