cmb Posted November 24, 2011 Share Posted November 24, 2011 i want to do some thing like this select sum(`no_Yards`) from `swimming` where `Season` = '0' only i want to sum the same colum no_Yards 6 different ways only changing the Season from 0 to 1 (and so on) something like this select sum(`no_Yards`) from `swimming` where `Season` = '0' select sum(`no_Yards`) from `swimming` where `Season` = '1' while only running 1 query but getting 6 different answers Link to comment https://forums.phpfreaks.com/topic/251706-multiple-sum-query/ Share on other sites More sharing options...
PFMaBiSmAd Posted November 24, 2011 Share Posted November 24, 2011 You would use GROUP BY Season Link to comment https://forums.phpfreaks.com/topic/251706-multiple-sum-query/#findComment-1290877 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.