/SQL/Duplicate a column in sql

Duplicate a column in sql

Sql query to find duplicates in column

SELECT name, COUNT(email) 
FROM users
GROUP BY email
HAVING COUNT(email) > 1

11

Source: stackoverflow.com

Sql how to duplicate a table

CREATE TABLE new_table LIKE original_table;
INSERT INTO new_table SELECT * FROM original_table;

1

Duplicate a column in sql

ALTER TABLE Table1
ADD SubCategory2 {Type of subcategory 1} {NULL|NOT NULL} 
UPDATE Table1 SET SubCategory2 = SubCategory;

0

Source: stackoverflow.com

Similar codes

0 vote199 views1 answer
Calculate date and convert to yearsmysql
SQL
3 votes221 views2 answers
Update Query in SQL Server
SQL
22 votes262 views4 answers
Mysql format date
SQL
0 vote236 views1 answer
Site:av.ru "files"
SQL
0 vote210 views1 answer
How many rows affected in sqllite
SQL
0 vote207 views1 answer
Oracle table free space
SQL
0 vote222 views1 answer
Less than date query sqlachemy
SQL
0 vote238 views1 answer
Mysql date without time
SQL
48 votes203 views3 answers
Psql create database
SQL
0 vote226 views1 answer
Mysql range of dates overlap
SQL

Share