Fetch duplicate records from a table in sql.
May 8, 2023
Answers (1)
Add Answer
Refere the following query to get the duplicate record, you can specify your table-related fields and get the result for the duplicate value.
SELECT Id, Name, COUNT(*)
FROM WalmartProducts
GROUP BY Id, Name
HAVING COUNT(*) > 1
