如果一个ID可以区分的话,可以这么写
如果几个ID才能区分的话,可以这么写
其他回答:数据表是zy_bho,想找出ZYH字段名相同的记录
select
*
from
表
where
ID
in
(
select ID from 表 group by ID having sum ( 1 ) > 1 )
select ID from 表 group by ID having sum ( 1 ) > 1 )
select
*
from
表
where
ID1
+
ID2
+
ID3
in
( select ID1 + ID2 + ID3 from 表 group by ID1,ID2,ID3 having sum ( 1 ) > 1 )
( select ID1 + ID2 + ID3 from 表 group by ID1,ID2,ID3 having sum ( 1 ) > 1 )
--
方法1:
SELECT * FROM zy_bho a WHERE EXISTS
( SELECT 1 FROM zy_bho WHERE [ PK ] <> a. [ PK ] AND ZYH = a.ZYH)
-- 方法2:
select a. * from zy_bho a join zy_bho b
on (a. [ pk ] <> b. [ pk ] and a.zyh = b.zyh)
-- 方法3:
select * from zy_bbo where zyh in
( select zyh from zy_bbo group by zyh having count (zyh) > 1 )
-- 其中pk是主键或是 unique的字段。
SELECT * FROM zy_bho a WHERE EXISTS
( SELECT 1 FROM zy_bho WHERE [ PK ] <> a. [ PK ] AND ZYH = a.ZYH)
-- 方法2:
select a. * from zy_bho a join zy_bho b
on (a. [ pk ] <> b. [ pk ] and a.zyh = b.zyh)
-- 方法3:
select * from zy_bbo where zyh in
( select zyh from zy_bbo group by zyh having count (zyh) > 1 )
-- 其中pk是主键或是 unique的字段。