2条回答 默认 最新
- 多鱼的夏天 2021-03-04 07:49关注
SELECT A,count(A) as count FROM
(SELECT A as A FROM table1
UNION ALL
SELECT B as A FROM table2
UNION ALL
SELECT C as A FROM table3)
GROUP BY username HAVING count(A) >1;本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏 举报
SELECT A,count(A) as count FROM
(SELECT A as A FROM table1
UNION ALL
SELECT B as A FROM table2
UNION ALL
SELECT C as A FROM table3)
GROUP BY username HAVING count(A) >1;