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 vote127 views1 answer
Sql missing values
SQL
0 vote119 views1 answer
Sql server check whether column has same equal values
SQL
5 votes112 views2 answers
Add column postgres with default value
SQL
0 vote105 views1 answer
Select value from previous row in postgresql
SQL
0 vote114 views1 answer
Sql query contains multiple ids
SQL
3 votes122 views2 answers
To_char sql
SQL
0 vote117 views1 answer
Connect to nginx server mysql remotly
SQL
6 votes121 views2 answers
Sql sequence
SQL
12 votes109 views4 answers
SQL Where
SQL
0 vote112 views1 answer
Selecting duplicates
SQL