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

0 vote382 views1 answer
Store case result sql
SQL
0 vote359 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL
0 vote352 views1 answer
Pl sql constraint user function
SQL
0 vote349 views1 answer
Sql last 7 days
SQL
3 votes335 views4 answers
Show sql server database
SQL
4 votes346 views1 answer
Postgresql change default value
SQL
0 vote355 views1 answer
Check if database exists sql
SQL
4 votes465 views3 answers
Mysql get column names from table
SQL
2 votes377 views2 answers
Mysql search for column name in all tables
SQL
1 vote388 views1 answer
Sql set auto increment back to 0
SQL