SELECT DATE(time_column) AS date, COUNT(*)
FROM table_name
GROUP BY DATE(time_column);
sql 按天分组查询
最新推荐文章于 2023-12-14 12:01:05 发布
SELECT DATE(time_column) AS date, COUNT(*)
FROM table_name
GROUP BY DATE(time_column);