How can we count and identify duplicate records in a table?

Question

how we can retrieve the unique values for the in a table without using the DISTINCT keyword

Answer 1

Try this code

SELECT count(*) AS duplicate_count
FROM (
 SELECT name FROM tbl
 GROUP BY name HAVING COUNT(name) > 1
) AS t