Search snippets
Browse Code Answers
FAQ
Usage docs
Log In
Sign Up
Home
SQL
sql insert for each distinct value
Bilal zaib
Programming language:
SQL
2021-02-26 19:18:35
0
Q:
sql insert for each distinct value
Nina Alex
Code:
SQL
2021-02-26 19:25:22
insert into your_table (col1, col2, col3) select distinct col1, 'newval', col3 from your_table
1
Tags
value
insert
sql
Related
sql select unique
SQL Insert Multiple Rows
sql query to find duplicates in column
select count distinct multiple columns sql server
select duplicates in sql
t-sql get duplicate rows
sql count having
case when with count and combining similar values in sql
sql delete duplicate rows but keep one
how to query without duplicate rows in sql
how to get non distinct values in sql
sql count distinct group by
sql select rows with different values in one column
sql get rows with duplicate values
select count of distinct values sql
sql server select rows by distinct column
New to Communities?
Join the community