I am wondering if there is any query that checks if all of the entries in a row are differing.
table family
familyID familyMember1 familyMember2 ... familyMember4
Instead of checking familyMember1 != familyMember2 , familyMember1 != familyMember3, ... familyMember3 != familyMember4, I want to implement a shorter check constraint. Is there a way to do this?
Thank you for your help.
Aucun commentaire:
Enregistrer un commentaire