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 Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/251706-multiple-sum-query/#findComment-1290877 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.