godfrank Posted May 9, 2006 Share Posted May 9, 2006 Helo folks!How can I use count() without GROUP BY?Thank you! 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() 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. Link to comment https://forums.phpfreaks.com/topic/9351-count-without-group-by/#findComment-34937 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.