17,382
社区成员




--2.sql实现如下:
select x.*
from (select t.*, row_number()over(partition by least(sitecode1,sitecode2)||greatest(sitecode1,sitecode2) order by 1) rn from tmp t) x
where rn = 1
--2.sql实现如下:
select x.*
from (select t.*, ,row_number()over(partition by least(sitecode1,sitecode2)||greatest(sitecode1,sitecode2) order by 1) rn from tmp t) x
where rn = 1