sql unique select code example

Example 1: sql insert for each distinct value

insert into your_table (col1, col2, col3)
select distinct col1, 'newval', col3
from your_table

Example 2: DISTINCT SQL

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