sql query for getting same data from database [closed]

It's difficult to tell what is being asked here. Th开发者_如何学Gois question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

My MYSQL database contains some fields which contains duplicate entries. I want to view all those rows which contains same data. Is there a query for this.

---

If mycolumn is the column that has duplicate data, you need to use the following:

SELECT mycolumn FROM mytable GROUP BY mycolumn HAVING COUNT(*) > 1