When you want to find all duplicate value in table, use this:
(adding more field to find more searching value criteria)

SELECT DISTINCT NAME, EMAIL
	,count(*)
FROM user
GROUP BY NAME, EMAIL
HAVING count(*) > 1;

Source: Here

Facebooktwittergoogle_plusredditpinterestlinkedinmailby feather

Written by Fikri Akbarsyah Anza, M.Kom

Lecturer