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 votes235 views2 answers
Oracle drop sequence
SQL
14 votes215 views3 answers
Trim sql
SQL
0 vote223 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
0 vote207 views1 answer
How to install mysql without admin rights
SQL
0 vote204 views1 answer
Default order by in mysql
SQL
0 vote198 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
18 votes188 views3 answers
Mysql query add column with default string value
SQL
0 vote215 views1 answer
System.Data.SqlClient.SqlException: 'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.' SqlDataAdapter
SQL
0 vote221 views1 answer
How to create a table in sql stack overflow
SQL
0 vote201 views3 answers
Get free card roblox
SQL