Select where duplicate mysql

Find duplicates mysql column

SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;

Source: stackoverflow.com

Select where duplicate mysql

SELECT 
    col1, COUNT(col1),
    col2, COUNT(col2)
FROM
    table_name
GROUP BY 
    col1, 
    col2
HAVING 
       (COUNT(col1) > 1) AND 
       (COUNT(col2) > 1);

Source: mysqltutorial.org

Similar codes

3 votes320 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
5 votes324 views1 answer
Oracle get foreign keys on table
SQL
0 vote329 views1 answer
Db format in quotation
SQL
0 vote320 views1 answer
Procedures sql insert mysql
SQL
0 vote324 views1 answer
Mysql group by range
SQL
0 vote345 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
16 votes377 views1 answer
Sqlserver add column to table
SQL
10 votes338 views1 answer
Oracle dependencies table
SQL
1 vote278 views1 answer
Mysql see column types
SQL
0 vote326 views1 answer
Hw to delete a procedure in pl sql
SQL