How to find duplicate value of a column value using mysql?

Question

I've a mysql table with the following data.

in the above image, some rows contains duplicate.

my question is how to find the repeated data in it?

For example : invoice_id = 19632, container duplicate data like BL No - NYKSMAAT20342300, Containers 3X40HC, 1X20GP and so on.

Pls help.

you have all in one column. That is terrible. Can you change the table structure? — juergen d
– juergen d, Commented Dec 11, 2017 at 12:02

Aman Kumar · Accepted Answer · 2017-12-11 12:09:40Z

1

Simple you can use this query to get duplicate entry from table

SELECT narration, COUNT(*) count FROM table GROUP BY narration HAVING count > 1;

answered Dec 11, 2017 at 12:09

Aman Kumar

4,5573 gold badges21 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Phoenix Over a year ago

Actually i've data like Chennai,Mumbai,Kolkata,Chennai,Bombay,Delhi,Mumbai. In the above content, i need to find Chennai and Mumbai Repeated twice. Hope understand my situation. kindly help me.

Collectives™ on Stack Overflow

How to find duplicate value of a column value using mysql?

1 Answer 1

Simple you can use this query to get duplicate entry from table

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Simple you can use this query to get duplicate entry from table

1 Comment

Related