Jump to content

Count() without GROUP BY


godfrank

Recommended Posts

[!--quoteo(post=372461:date=May 8 2006, 07:26 PM:name=godfrank)--][div class=\'quotetop\']QUOTE(godfrank @ May 8 2006, 07:26 PM) [snapback]372461[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Helo folks!

How can I use count() without GROUP BY?
Thank you!
[/quote]
You're not supposed to be able to at all -- this is an aggregate function, and hence requires something aggregate to work on. MySQL just assumes that you implicitly mean the entire result set, but you shouldn't rely on this.
Link to comment
https://forums.phpfreaks.com/topic/9351-count-without-group-by/#findComment-34937
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.