/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

5 votes195 views1 answer
Mysql count newlines in field
SQL
-2 votes188 views1 answer
Modify column name in tsql
SQL
12 votes183 views1 answer
Env var for setting password for root user mysql docker hub
SQL
0 vote274 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote221 views1 answer
Oracle string length
SQL
24 votes207 views6 answers
Rename a column in sql server
SQL
0 vote202 views1 answer
Mysql in clausule string array
SQL
0 vote191 views1 answer
Oracle array
SQL
0 vote255 views1 answer
ALV GRID events
SQL
0 vote192 views1 answer
Tsql generate rows
SQL

Share