mysql 的gruop by 用法,并不遵循标准的sql语法写法。如,
SELECT * FROM bip_sysnotice_not_read
这里想按account_id分组查时间最小的那么数据库
分组查询的时候不要select *,比如像这样是不对的:
SELECT *
FROM bip_sysnotice_not_read
WHERE site_id =2
GROUP BY account_id
HAVING MIN(create_time) BETWEEN DATE_SUB(NOW(),INTERVAL 36 HOUR) AND DATE_SUB(NOW(),INTERVAL 24 HOUR)
:
不指定分组字段,在 mysql 虽然不会报错,但是得出的结果不一定是对的
正确的写法应该遵循标准的group by 语法,指定分组字段,如
SELECT account_id,MIN(create_time) min_time
FROM bip_sysnotice_not_read
WHERE site_id =2
GROUP BY account_id
HAVING min_time BETWEEN DATE_SUB(NOW(),INTERVAL 36 HOUR) AND DATE_SUB(NOW(),INTERVAL 24 HOUR)