Jump to content

multiple sum query


Recommended Posts

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
Share on other sites


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.