select c1,c2,c3,c4,c5
from (
select c1,c2,c3,c4,c5,row_number() over(partition by c5 order by c1) rn from tablename
)
where rn = 1;c1 ..5分别代表你的列1 。。列5
from (
select c1,c2,c3,c4,c5,row_number() over(partition by c5 order by c1) rn from tablename
)
where rn = 1;c1 ..5分别代表你的列1 。。列5
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货