DISQUS

DISQUS Hello! Code Spatter is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

Jump to original thread »
Author

Conditions on Count or Sum in MySQL

Started by Greg Allard · 10 months ago

When selecting count, sum, or some other aggregate function, the value isn’t determined until after the WHERE clause so a condition can’t be placed there. There is still syntax for specifying a condition for this, it is to use HAVING.
The following example is to cou ... Continue reading »

3 comments

Add New Comment

Returning? Login