我正在寻找一个单一的查询,它可以给出在某个日期范围之间只出现一次的client_id的总出现次数 .
我有下面的查询返回总数但在添加日期范围时出错
SELECT COUNT(cnt) FROM (SELECT COUNT(*) AS cnt FROM loans l5 GROUP BY l5.client_id HAVING cnt < 2) AS a
下面的查询将为您提供其等于1的客户端ID出现的总数 . 只需在“where”子句中添加日期逻辑
select count(cnt) from ( SELECT COUNT(*) AS cnt FROM loans l5 where <YOUR DATE LOGIC> GROUP BY l5.client_id HAVING cnt = 1) a
1 回答
下面的查询将为您提供其等于1的客户端ID出现的总数 . 只需在“where”子句中添加日期逻辑