Duplicate table sql

CREATE TABLE new_table LIKE original_table;

Source: popsql.com

Duplicate in sql

• SELECT first_name, COUNT (first_name) FROM employees
GROUP BY first_name
HAVING (COUNT(first_name) > 1);

Sql how to duplicate a table

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

Duplicate records in sql

Multiple field=
SELECT username, email, COUNT(*)
FROM users
GROUP BY username, email
HAVING COUNT(*) > 1

Single field=
SELECT _column, COUNT(*) 
FROM _table
GROUP BY _column
HAVING COUNT(*) > 1

Duplicate a column in sql

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

Source: stackoverflow.com

Similar codes

2 votes362 views1 answer
Query to find table size in oracle 12c
SQL
1 vote353 views1 answer
Pl sql insert into table
SQL
0 vote378 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
3 votes381 views2 answers
Check data in table mysql
SQL
1 vote346 views1 answer
Oracle aleter trigger ora-01031
SQL
6 votes391 views2 answers
How to copy data in sql
SQL
17 votes374 views6 answers
What is cursor in sql server with example
SQL
24 votes384 views5 answers
List mysql users
SQL
0 vote382 views1 answer
How to get one year old query from plan cache
SQL
0 vote336 views1 answer
Postgressql uuid
SQL