PLEASE EXPLAIN THE QUERY - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

PLEASE EXPLAIN THE QUERY

Author

Topic

gnanasekar
Starting Member

6 Posts

Posted - 2011-08-03 : 11:33:57

Select * From Employees E1 Where
(N-1) = (Select Count(Distinct(E2.Salary)) From Employees E2 Where
E2.Salary > E1.Salary)

EXPLAIN THE QUERY AND WHAT IS THE MEANING (N-1)

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2011-08-03 : 11:44:13

Dupe post:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=163840

please only post your question once.

Be One with the Optimizer
TG

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources