Answers for "select distinct values from one table insert into another"

sql insert for each distinct value

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

Posted by: Guest on April-30-2020

Code answers related to "select distinct values from one table insert into another"