3,491
社区成员
发帖
与我相关
我的任务
分享
select * from test0407 t0 where t0.rowid not in(
select distinct rowid from test0407 t1
start with (t1.no1 > 0 or t1.no2 > 0)
connect by nocycle (prior t1.no1 = t1.no1 or prior t1.no1 = t1.no2 or prior t1.no2 = t1.no1 or prior t1.no2 = t1.no2)
)
;