How to Find duplicate Records?

If someone want to find out duplicate rows can use this SELECT statement!

If SELECT displays same records, you can use this DELETE statement below:

I know that it is trivial but it can be very helpful!