sql对两个字段同时去重

 

select user.Id,user.name 
from 
(
select 
    Id,
    name,
    sex,
    row_number() over(partition by Id,cardId order by 1) as d
from m_user
)user where user.d = 1