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

1 vote200 views1 answer
Sql server delete top 1000
SQL
1 vote139 views1 answer
Create new table in SQL from old table with data
SQL
1 vote144 views1 answer
Select users with same username
SQL
0 vote144 views1 answer
Mysql date time string format for marshmellow field schema
SQL
0 vote139 views1 answer
SQL isnumeric DB2
SQL
3 votes136 views1 answer
Oracle list dates without weekends
SQL
0 vote178 views1 answer
Sql filter rows with condition
SQL
0 vote175 views1 answer
Sql declare variable single line
SQL
0 vote136 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL
0 vote138 views1 answer
Limit and offset in stored procedure mssql
SQL