sql unqiue code example

Example 1: DISTINCT SQL

SELECT DISTINCT column1, column1, ..... FROM TABLE
/*DISTINCT WILL NOT SELECT THE SAME VALUES IN SAME COLUMN*/

Example 2: set column as unique in sql server

ALTER TABLE Persons
ADD UNIQUE (ID);