查找两个表中xh字段重复的记录

Question

在ct_brxsxm和ct_lsxsxm两个表中找到xh字段中重复的记录。用的语句是什么？谢谢。

Answer 1

这2个表union all后，group by xh字段，having count(*)>1即可找出出现次数大于1次的xh记录； 

---

family as water

Answer 2

你好，

以下查询也可以查找出两表中的某个字段都相同的记录。

select * from table1 t1 where exists(select 1 from table2 t2  where t2.xh=t1.xh)

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.

Answer 3

select * from ct_brxsxm t1 where exists(select 1 from ct_lsxsxm t2  where t2.xh=t1.xh);     查询成功了，万分感谢。

Answer 4

你好，

如果您觉得我的回复对你有所帮助，请帮忙‘标记为答案'以帮助其他社区成员迅速找到有用的答复。你可以标记多个有效答案。

此外，如果您还有其他问题，请随时提出。

谢谢

---

""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
For more information, please refer to the sticky post.