HANA数据库查询重复行

ag • 2018.07.25 09:44 • 文章 • 阅读 2036

--查询重复行
select "CustID"
from "DW2"."Customer"
where "CustID" in(select "CustID" from "DW2"."Customer" group by "CustID" having count(1)>=2)

--查询重复行

select "CustID"

from "DW2"."Customer"

where "CustID" in(select "CustID" from "DW2"."Customer" group by "CustID" having count(1)>=2)

本文作者: GavinDong

如果使用过程中遇到问题，可 **点击此处** 交流沟通。