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

5 votes117 views1 answer
Oracle add time to date
SQL
0 vote100 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote98 views1 answer
Sql server port 1434
SQL
2 votes101 views1 answer
Oracle number to percentage
SQL
0 vote102 views1 answer
Sql offfset
SQL
0 vote97 views1 answer
Min:sec datediff mssql
SQL
0 vote113 views1 answer
Hour and minute between two datatime sql
SQL
6 votes106 views1 answer
Postgresql add enum value
SQL
0 vote132 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote109 views1 answer
Check the size of the tables here ordered from the biggest size
SQL