在php中按列Date计算列的总和

Question

How to calculate the sum of a column by a date column?

I have id column and call_time column. I want to get the sum of id column based on call_time.

This is my sample table

Answer 1

You can use SUM() function on required column with GROUP BY clause

SELECT SUM(id) FROM your_table GROUP BY call_time