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 vote125 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
0 vote121 views1 answer
Order by monthly in sql
SQL
0 vote138 views1 answer
Mysql workbench primary key
SQL
18 votes123 views3 answers
Mysql number format
SQL
0 vote138 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote136 views2 answers
Find lowest number in sql
SQL
16 votes121 views1 answer
Sqlserver add column to table
SQL
1 vote126 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote162 views1 answer
Bash block size ls /var/lib/mysql
SQL
1 vote133 views1 answer
Postgresql transaction discard all
SQL