Breaking News: Grepper is joining You.com. Read the official announcement!

mysql find duplicate rows multiple columns

Add Answer

ShanK answered on April 20, 2020 Popularity 8/10 Helpfulness 4/10

answer mysql find duplicate rows multiple columns

related find duplicates mysql column

related finding duplicate rows mysql

related mysql find duplicates in same table

related finding duplicate rows mysql

related Mysql Selected All Duplicate Rows

related select duplicate rows by one field mysql

mysql find duplicate rows multiple columns

Comment

-1

-- multiple columns
SELECT COUNT(*) c , 
CONCAT(students.first_name, "----",students.last_name) 
FROM students WHERE students.class_id = classes.id
GROUP BY CONCAT(first_name,"----",last_name) HAVING c > 1;

Popularity 8/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: find multiple-columns mysql rows sql

Link to this answer
Share Copy Link

Contributed on Sep 14 2022

ShanK

0 Answers Avg Quality 2/10

Closely Related Answers

find duplicates mysql column

Comment

SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;

Popularity 10/10 Helpfulness 10/10 Language sql

Source: stackoverflow.com

Tags: find

Link to this answer
Share Copy Link

Contributed on Apr 20 2020

Enthusiastic Elephant

0 Answers Avg Quality 2/10

finding duplicate rows mysql

Comment

SELECT varchar_col
FROM table
GROUP BY varchar_col
HAVING COUNT(*) > 1;

Popularity 10/10 Helpfulness 7/10 Language sql

Source: stackoverflow.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Oct 20 2021

Itchy Iguana

0 Answers Avg Quality 2/10

mysql find duplicates in same table

Comment

## Find ALL duplicate recods by value (without grouping them by value) ##
# to find the duplicate, 
# replace all instances of tableName with your table name
# and all instances of duplicateField with the field name where you look for duplicates
SELECT t1.*
FROM tableName AS t1
INNER JOIN(
	SELECT duplicateField
	FROM tableName
	GROUP BY duplicateField
	HAVING COUNT(duplicateField) > 1
)temp ON t1.duplicateField = temp.duplicateField
order by duplicateField

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: find

Link to this answer
Share Copy Link

Contributed on Dec 22 2020

Yoshkinawa

0 Answers Avg Quality 2/10

finding duplicate rows mysql

Comment

SELECT name, COUNT(*) c FROM table GROUP BY name HAVING c > 1;

Popularity 9/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Oct 20 2021

Itchy Iguana

0 Answers Avg Quality 2/10

Mysql Selected All Duplicate Rows

Comment

select t.*
from table t
where exists (select 1 from table t2 where t2.url = t.url and t2.id <> t.id);

Popularity 9/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: mysql mysq

Link to this answer
Share Copy Link

Contributed on Jan 28 2022

Alert Ant

0 Answers Avg Quality 2/10

select duplicate rows by one field mysql

Comment

SELECT  *
FROM    mytable mto
WHERE   EXISTS
        (
        SELECT  1
        FROM    mytable mti
        WHERE   mti.varchar_column = mto.varchar_column
        LIMIT 1, 1
        )
ORDER BY varchar_column

Popularity 4/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: field mysql rows select sql

Link to this answer
Share Copy Link

Contributed on Jul 04 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

select duplicate rows by one field mysql

Comment

SELECT GROUP_CONCAT(id), name, COUNT(*) c
FROM documents
GROUP BY name
HAVING c > 1;

Popularity 5/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: field mysql rows select sql

Link to this answer
Share Copy Link

Contributed on Jul 04 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

select duplicate rows by one field mysql

Comment

SELECT varchar_col
FROM table
GROUP BY varchar_col
HAVING COUNT(*) > 1;

Popularity 5/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: field mysql rows select sql

Link to this answer
Share Copy Link

Contributed on Jul 04 2023

Vivacious Vulture

0 Answers Avg Quality 2/10

mysql find duplicate rows multiple columns

Contents

More Related Answers

mysql find duplicate rows multiple columns

Closely Related Answers

find duplicates mysql column

finding duplicate rows mysql

mysql find duplicates in same table

finding duplicate rows mysql

Mysql Selected All Duplicate Rows

select duplicate rows by one field mysql

select duplicate rows by one field mysql

select duplicate rows by one field mysql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.