查询相同记录大于等于2条如何查？

nicholasvb 2012-03-26 11:02:23

查询cvencode，cinvcode,ilowerlimit这三个字段都相同且>=2条的记录

...全文

611 7 打赏收藏转发到动态举报

写回复

用AI写文章

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

开着拖拉机泡妞 2012-03-26

打赏
举报



select cvencode，cinvcode,ilowerlimit from tbl

where cvencode=cinvcode=ilowerlimit 

group by cvencode，cinvcode,ilowerlimit having count(*)>=2

黄_瓜 2012-03-26

打赏
举报

select cvencode，cinvcode,ilowerlimit from T

group by cvencode，cinvcode,ilowerlimit

having count(1) >2

xuam 2012-03-26

打赏
举报

select cvencode，cinvcode,ilowerlimit from T
group by cvencode，cinvcode,ilowerlimit
having count(1) >2

开着拖拉机泡妞 2012-03-26

打赏
举报

[Quote=引用楼主 nicholasvb 的回复:]
查询cvencode，cinvcode,ilowerlimit这三个字段都相同且>=2条的记录
[/Quote]

给出详细测试数据和结果

nicholasvb 2012-03-26

打赏
举报

[Quote=引用 6 楼 xuam 的回复:]

SQL code
select * from Ven_Inv_Price a exists(select cVenCode,cInvCode,iLowerLimit from ven_inv_price group by cInvCode,cVenCode,iLowerLimit having COUNT(*)>1)
[/Quote]
我要的是cVenCode,cInvCode,iLowerLimit这三列都重复的记录你的是全查出来了

xuam 2012-03-26

打赏
举报

select * from Ven_Inv_Price a exists(select cVenCode,cInvCode,iLowerLimit from ven_inv_price group by cInvCode,cVenCode,iLowerLimit having COUNT(*)>1)

nicholasvb 2012-03-26

打赏
举报

select * from Ven_Inv_Price a where (a.cVenCode,a.cInvCode,a.iLowerLimit) in (select cVenCode,cInvCode,iLowerLimit from ven_inv_price group by cInvCode,cVenCode,iLowerLimit having COUNT(*)>1)
我这样写提示错误：在应使用条件的上下文(在 ',' 附近)中指定了非布尔类型的表达式。