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

13 votes177 views2 answers
Get date from now() mysql
SQL
3 votes179 views1 answer
Ms sql skip take
SQL
1 vote187 views1 answer
Get last week data in mysql
SQL
0 vote187 views1 answer
MySQL import data from large CSV file
SQL
0 vote210 views1 answer
Traccar mysql
SQL
1 vote194 views1 answer
Psql import backup file for windows
SQL
0 vote269 views1 answer
Mysql show schema
SQL
1 vote133 views1 answer
How to run sql script
SQL
0 vote144 views0 answer
SQL
0 vote175 views1 answer
Concat column value of same user in mysql
SQL