如何为数据库中的记录标记设置“优先级”？

I have a query that currently finds duplicates and it works fine. The issue is that some records have a field called DS which can have 2 possible values. VOTER or DMV.I have a query that currently finds duplicates