According to the time field time total data query four quarters in every quarter

CodePudding user response:

The select QUARTER (TIME), sum (num) from table group by QUARTER (TIME)

CodePudding user response:

With this condition is perfect