SELECT COUNT(a.uid) AS last_1_2_count FROM
(
SELECT DISTINCT uid,MAX(hfdate) AS max_hfdate,POSITION,checked FROM hrdk.dk_hf GROUP BY uid
) AS a
WHERE (a.max_hfdate BETWEEN UNIX_TIMESTAMP(DATE_SUB(CURDATE(),INTERVAL 2 DAY)) AND UNIX_TIMESTAMP(DATE_SUB(CURDATE(),INTERVAL 1 DAY)))
AND a.position>0 AND a.checked=2这个结果是:36745
*****************************************************************************SELECT COUNT(a.uid) AS last_1_2_count FROM
(
SELECT DISTINCT uid,MAX(hfdate) AS max_hfdate,POSITION,checked FROM hrdk.dk_hf WHERE POSITION>0 AND checked=2 GROUP BY uid
HAVING max_hfdate BETWEEN UNIX_TIMESTAMP(DATE_SUB(CURDATE(),INTERVAL 2 DAY)) AND UNIX_TIMESTAMP(DATE_SUB(CURDATE(),INTERVAL 1 DAY))
)
AS a 这个结果是:37067求大神指导,问题是出在having上吗?SQLMySQL
解决方案 »
- mysql 中存储过程动态生成sql语句执行的问题
- mysql数据库中怎样实现,若表中不存在某个字段,就添加一个字段?
- MYSQL高手过来帮解决一个行列互转的问题
- 在哪能够下载到一个免安装的mySQL版本,4.X或5.X均可
- 大家来看看我做的页面,所有提意见的都有分拿!!!散分
- 我的win2000装在d盘,c盘装的win xp,我的mysql安装在d;\mysql下,mysql无法运行,怎么呢?!
- hql 连接查询 右连接
- 【急问】关于INSERT后,获取到自增长ID
- 求助高人指点小虾米:访问mysql是遇到编译问题!
- 请教个问题关于update
- 关于数据表设计思路和其它几个问题
- Mysql 插入特殊字符的时候如何处理?
一个后group by而where过滤条件不是group by的那个字段
HAVING max_hfdate BETWEEN UNIX_TIMESTAMP(DATE_SUB(CURDATE(),INTERVAL 2 DAY)) AND UNIX_TIMESTAMP(DATE_SUB(CURDATE(),INTERVAL 1 DAY))这2个SQL语句条件都 不同,结果肯定有差异