SELECT * FROM zy_bho a WHERE EXISTS (SELECT 1 FROM zy_bho WHERE [PK] <> a.[PK] AND ZYH = a.ZYH)
select * from zy_bbo where zyh=(select zyh from zy_bbo group by zyh where count(zyh)>1)
上面的语句有点小问题,应该为: select * from zy_bbo where zyh in (select zyh from zy_bbo group by zyh where count(zyh)>1)
用下面语句即可实现:select * from zy_bho group by zyh having count(zyh)>1;
至少存在三种解法。 Arionma() 的是一种。gmlxf(烛光) 的一种。 还有一种是 select a.* from zy_bho a join zy_bho b on (a.[pk] != b.[pk] and a.zyh = b.zyh)pk是主键或是unique 的字段。rowid也行to cthxyw(xyw) : select 的列 必须要落在 group by 或者是集合函数里。
select * from tablename where zy_bho iin (select zy_bho from tablename group by zy_bho having count(zy_bho)>1)
楼上真正正确的答案好象少吧,我整理一下并且修改一下小错误: 1 --我的 SELECT * FROM zy_bho a WHERE EXISTS (SELECT 1 FROM zy_bho WHERE [PK] <> a.[PK] AND ZYH = a.ZYH)2 --sjjf(水晶剑锋) 的 select a.* from zy_bho a join zy_bho b on (a.[pk] <> b.[pk] and a.zyh = b.zyh)3 --Arionma() 的 select * from zy_bbo where zyh in (select zyh from zy_bbo group by zyh having count(zyh)>1)pk是主键或是unique 的字段。
FROM zy_bho a
WHERE EXISTS
(SELECT 1 FROM zy_bho WHERE [PK] <> a.[PK] AND ZYH = a.ZYH)
select * from zy_bbo where zyh in (select zyh from zy_bbo group by zyh where count(zyh)>1)
还有一种是
select a.* from zy_bho a join zy_bho b
on (a.[pk] != b.[pk] and a.zyh = b.zyh)pk是主键或是unique 的字段。rowid也行to cthxyw(xyw) : select 的列 必须要落在 group by 或者是集合函数里。
(select zy_bho from tablename group by zy_bho having count(zy_bho)>1)
1 --我的
SELECT *
FROM zy_bho a
WHERE EXISTS
(SELECT 1 FROM zy_bho WHERE [PK] <> a.[PK] AND ZYH = a.ZYH)2 --sjjf(水晶剑锋) 的
select a.* from zy_bho a join zy_bho b
on (a.[pk] <> b.[pk] and a.zyh = b.zyh)3 --Arionma() 的
select * from zy_bbo where zyh in (select zyh from zy_bbo group by zyh having count(zyh)>1)pk是主键或是unique 的字段。