Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can this be faster
Message
From
29/10/2015 13:12:30
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2014
Application:
Desktop
Miscellaneous
Thread ID:
01626554
Message ID:
01626637
Views:
49
Likes (1)
>>Sergey, you can't use MAX in a WHERE clause. Only in a HAVING, or within context of a subquery. (And I see Naomi just posted the same thing)
>>
>> Do you test code before posting it? :)
>
>So replace WHERE with HAVING. What is a big deal?

It's like the use of a comma. It's the difference between...

"We're going to eat, Grandma"

and

"We're going to eat Grandma"

Small detail, big difference :)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform