select c.*
from(select row_number() over (partition by r.c_id order by similar desc) rn, r.* from tb_d_c_rs r) c where c.rn = 1
partition by为分组依据,order by 是排序依据。
from(select row_number() over (partition by r.c_id order by similar desc) rn, r.* from tb_d_c_rs r) c where c.rn = 1
partition by为分组依据,order by 是排序依据。