17,377
社区成员
发帖
与我相关
我的任务
分享
--把两条都去掉
select b,c,d,e from (
select b,c,d,e,count(a) rn
from A
group by b,c,d,e
)
where rn=1;
select a,b,c,d,e from (
select a,b,c,d,e,row_number()over(partition by b,c,d,e order by a) rn
from A
)
where rn=1;