godfrank Posted May 9, 2006 Share Posted May 9, 2006 Helo folks!How can I use count() without GROUP BY?Thank you! Quote Link to comment https://forums.phpfreaks.com/topic/9351-count-without-group-by/ Share on other sites More sharing options...
.josh Posted May 9, 2006 Share Posted May 9, 2006 umm...that depends. for instance:[!--coloro:blue--][span style=\"color:blue\"][!--/coloro--] select count(columnnamehere) as total from tablename[!--colorc--][/span][!--/colorc--]returnstotal===xwhere x is the total returned from count() Quote Link to comment https://forums.phpfreaks.com/topic/9351-count-without-group-by/#findComment-34509 Share on other sites More sharing options...
fenway Posted May 10, 2006 Share Posted May 10, 2006 [!--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. Quote Link to comment https://forums.phpfreaks.com/topic/9351-count-without-group-by/#findComment-34937 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.