实现代码:
select tmp.* from(
select ROW_NUMBER() OVER(partition by u.id order by u.name) rn,
u.id,
u.name,
u.password pwd
from tb_user u
group by
u.id,
u.name,
u.password
)tmp
where rn = 1
实现代码:
select tmp.* from(
select ROW_NUMBER() OVER(partition by u.id order by u.name) rn,
u.id,
u.name,
u.password pwd
from tb_user u
group by
u.id,
u.name,
u.password
)tmp
where rn = 1