SELECT COUNT(uuid) FROM ( SELECT uuid,SUM(page_a_cnt) AS sum_a,SUM(page_b_cnt) AS sum_b FROM ( SELECT uuid,IF(pageId=pageA,1,0) AS page_a_cnt,IF(pageId=pageB,1,0) AS page_b_cnt FROM tb WHERE pageId=pageA OR pageId=pageB ) t1 GROUP BY uuid ) t2 WHERE t2.sum_a>0 AND sum_b>0
1 3

相关推荐

求面试求offer啊啊啊啊:这个在牛客不是老熟人了吗
点赞 评论 收藏
分享
有担当的灰太狼又在摸鱼:零帧起手查看图片
点赞 评论 收藏
分享
牛客网
牛客企业服务