In what situations will this be beneficial in? If you can.
In same table?
Yes definitely you can have.
In what situation?
That depends, one example would be: say you have a synthetic ID column in your table designated as primary key (
AUTO_INCREMENT) but you want
FirstName of the customer to be unique always. In that case define a
UNIQUE constraint on the