HANA数据库查询重复行

--查询重复行
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)

要发表评论，您必须先登录。