-
help me out
table balances
(SSN
BALANCE_TYPE_ID
BALANCE_NAME
BALANCE_DIMENSION_ID
JURISDICTION_CODE
AMOUNT
FLAG )
i want to enforce unique constraint on the above table , for the combination of ssn and balance_type_id,
but since the combiantion has dupilcate values, i am not able to enforce it.is there any way
to find duplicate values for this particular unique combination,so that i can delate it and enforce the unique
constraint.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|