嘻嘻啧啧: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