1.0.621 Secs
select a.dwbm,a.grxh,a.xm from yw_ick a,yw_ick b where a.dwbm=b.dwbm and a.grxh=b.grxh and a.rowid<b.rowid
2.4.337 Secs
select dwbm||','||grxh,count(dwbm||','||grxh)
from yw_ick
group by dwbm||','||grxh
having count(*)>1
order by dwbm||','||grxh