How To Check For Duplicates Rows In Database Tables

SELECT id, upc, count( upc ) AS n
FROM amazon
GROUP BY upc
HAVING n >1
ORDER BY upc
LIMIT 0 , 30