随笔分类 -  mysql

摘要：select hour(create_time) AS saleHour, count(id) AS saleCount from tableName where date_format(create_time, ‘%Y-%m-%d’ ) = ‘2021-09-07’ group by hour(c 阅读全文