/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 vote118 views1 answer
Oracle search in date columns
SQL
2 votes97 views2 answers
How to create an empty table from an existing table
SQL
3 votes112 views1 answer
Sql online test questions and answers
SQL
0 vote149 views1 answer
Grouping by email domain mysql
SQL
0 vote71 views3 answers
Mysql calculate age from date of birth
SQL
0 vote110 views1 answer
Sql server select record with max id
SQL
0 vote104 views1 answer
Create table employees oracle
SQL
0 vote115 views2 answers
How to take recent row without limit in mysql
SQL
18 votes133 views2 answers
Sql comments
SQL
0 vote117 views1 answer
Sp in sql server
SQL

Share