1. Unique – It ensures that no two rows have the same value in a column while storing data. It is used with create command.
2. Distinct – This keyword is used to avoid duplicate values in a column of a table while retrieving data. It is used with select command.