Which query would you use to display duplicate records into the table ? 😇 😇

Question

Comment your mind answer 😇

Answer 1

display it..

Answer 2

http://www.w3schools.com/sql/sql_func_count.asp

Answer 3

i think something like this should work:

SELECT a.*, b.totalCount AS Duplicate FROM tablename a
INNER JOIN
(
SELECT email, COUNT(*) totalCount
FROM tableName
GROUP BY email
) b ON a.email = b.email
WHERE b.totalCount >= 2

Answer 4

You want to get rid of duplicates? Or find them and display them?

Answer 5

you could make a condition with COUNT()

Answer 6

maybe like this? select * from employee where count(id)>1

Answer 7

Use max rowid with group by columns....