PARTITION BY组合字段重复

rn = ROW_NUMBER() OVER (PARTITION BY part, nbr ORDER BY part)
            FROM tb
                  )

rn则为part和nbr字段组合的排序值，若rn大于1则表示此记录为根据part和nbr组合重复的记录。