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.

Answer 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;