{
"id": 0,
"code": null,
"source": null,
"target": null,
"box_code": null,
"state": null,
"type": null,
"create_time": "2021-07-21 00:48:43",
"finish_time": null,
"update_user": null,
"count": "1"
},
{
"id": 0,
"code": null,
"source": null,
"target": null,
"box_code": null,
"state": null,
"type": null,
"create_time": "2021-07-21 00:49:13",
"finish_time": null,
"update_user": null,
"count": "1"
},
{
"id": 0,
"code": null,
"source": null,
"target": null,
"box_code": null,
"state": null,
"type": null,
"create_time": "2021-07-21 00:54:31",
"finish_time": null,
"update_user": null,
"count": "1"
},
{
"id": 0,
"code": null,
"source": null,
"target": null,
"box_code": null,
"state": null,
"type": null,
"create_time": "2021-07-21 00:56:05",
"finish_time": null,
"update_user": null,
"count": "1"
},
{
"id": 0,
"code": null,
"source": null,
"target": null,
"box_code": null,
"state": null,
"type": null,
"create_time": "2021-07-21 00:57:00",
"finish_time": null,
"update_user": null,
"count": "1"
},
{
"id": 0,
"code": null,
"source": null,
"target": null,
"box_code": null,
"state": null,
"type": null,
"create_time": "2021-07-22 00:57:00",
"finish_time": null,
"update_user": null,
"count": "1"
},
我的sql是
SELECT create_time,COUNT(*) AS COUNT FROM wcs_task WHERE DATE_SUB(CURDATE(), INTERVAL 7 DAY) <= DATE(create_time) AND type = 'put_box' GROUP BY create_time HAVING COUNT>1;
相同的时间不能相加
目前是有5个数据是重复的 根据这个2021-07-21统计 那么重复的count是5条 目前count都是1条一条的 需要将所有单个count相加 07-22这个是未重复 的count=1 sql该怎么写
截取create_time然后group by
给你个思路，group by的同时再求个sum(count)
count是你字段中的值，均为1，可以求出一共多少条数据 我起别名为S1。
把这个语句当作子查询，外部增加个查询求count()，可以求出未重复的值，我起别名为C1。
select count(),S1
from(
上一条语句
)
S1 = 总
C1 = 未重复
S1 - C1 = 重复的