spirose
asked on
SQL - no duplicate row of combination of ColumnA and ColumnB
This query is for quality check on a TableAB- query checks that there is no duplicate row with the same values of ColumnA and ColumnB.
Example:
ColumnA ColumnB ColumnC ColumnD
2 6 22 23
2 6 26 42
This case above should not happen. The query needs to return such records if they exist.
Example:
ColumnA ColumnB ColumnC ColumnD
2 6 22 23
2 6 26 42
This case above should not happen. The query needs to return such records if they exist.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER