row_number() over (partition by a.unino order by a.unino) numc
select row_number() over (partition by a.unino order by a.unino) ,a.*
from
zn_gcustomer a
left join zn_gcmanagement b on a.unino=b.unino
left join zn_custinfo c on b.cino=c.cino
先做到类排序,然后在取=1的就可以了