Finding Duplicates on a Column Subset with Detail

To select rows with out duplicates change the WHERE clause to “RowCnt = 1”
To select one row from each set use Rank() instead of Sum() and change the outer WHERE clause to select rows with Rank() = 1

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents