我的数据如下所示
我的数据表如下所示:
client_id Status
1 a
1 b
1 d
1 e
2 a
2 d
3 a
3 b
3 e
4 a
4 d
5 b
我需要按状态同时具有a和d值的客户端进行分组
上面的结果集应该返回
client_id a_d_Flag
1 Yes
2 Yes
3 No
4 Yes
5 No
-oh my 天.
SELECT c.client
, CASE WHEN c.Status = 'a' AND c.status = 'd'
THEN 'Yes'
ELSE 'No'
END AS a_d_Flag
FROM client_details c
GROUP BY c.client
HAVING c.Status = 'a' AND c.status = 'd'