Finding Duplicates on a Column Subset with Detail:
*Finding Duplicates on a Column Subset with Detail
Finding Duplicates on a Column Subset with Detail
suggest changeRemarks
- 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.