
SQL开发知识:SQL对数据进行按月统计或对数据进行按星期统计的实例
SELECT DATE_FORMAT(date, ‘%Y-%m’) AS month, COUNT(*) FROM table GROUP BY month;,SELECT DAYOFWEEK(date) AS we...
SELECT DATE_FORMAT(date, ‘%Y-%m’) AS month, COUNT(*) FROM table GROUP BY month;,SELECT DAYOFWEEK(date) AS we...