mysql在一个月内平均每天获取客户端

bjg7j2ky 于 2021-06-23 发布在 Mysql

关注(0)|答案(1)|浏览(298)

SELECT COUNT(client_ID) / DAY(LAST_DAY(dateRequested))
FROM `tbl_client`
WHERE dateRequested BETWEEN  DATE_FORMAT(dateRequested,'%Y-%m-01') AND LAST_DAY(dateRequested)

我想显示一个月内每天的平均客户数

client_ID   |   dateRequested
   1        |   2018-07-04
   2        |   2018-07-05
   3        |   2018-07-06
   4        |   2018-07-07
   5        |   2018-08-04
   6        |   2018-08-06
   7        |   2018-08-09

我想展示给你看

Average  |     Month
4        |   July 2018
3        |   August 2018

sql mysql

来源：https://stackoverflow.com/questions/51777682/mysql-getting-average-of-client-per-day-in-a-month

1条答案

按热度按时间

5cnsuln71#

尝试以下查询：

SELECT COUNT(client_ID),concat(month(dateRequested),year(dateRequested)) 
FROM `tbl_client`
WHERE dateRequested BETWEEN  DATE_FORMAT(dateRequested,'%Y-%m-01') AND LAST_DAY(dateRequested)
group by concat(month(dateRequested),year(dateRequested))

赞(0）回复(0）举报 2021-06-23

我来回答

mysql在一个月内平均每天获取客户端

1条答案

相关问题

热门标签

最新问答