/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

1 vote364 views1 answer
T-sql disable system versioning
SQL
0 vote313 views1 answer
Mysql_error replacement
SQL
0 vote321 views1 answer
Alter database name script
SQL
3 votes325 views2 answers
Monthname sql
SQL
1 vote308 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
1 vote340 views1 answer
Deleting database in sql
SQL
34 votes356 views5 answers
Oracle alter table add column
SQL
34 votes320 views6 answers
Sql change data type
SQL
0 vote312 views1 answer
Sql server select ignore dupplicates
SQL
4 votes342 views2 answers
Sql offset
SQL

Share