SQL | Find duplicate records in table using COUNT and HAVING |Simple method to find duplicate record

In this video we see how to find duplicate records using COUNT and HAVING in SQL.

By using the COUNT function in the HAVING clause to check if any of the groups have more than 1 entry, those would be the duplicate values.

Using COUNT and HAVING is one of the easiest method to find duplicate values in SQL.

"Thanks for watching. If you liked this video, make sure to subscribe for more!”

#dataprojecthub
#data_project_hub

[belindafraser]

Lovely clear explanation - thank you very much!

[tutsecret]

Because I encounter a lot bad design database structure, usually there is no primary keys ID, etc. So how I set up the sql just to find Firstname and Lastname if there is duplicate of names. In excel is easy, but I want to learn in Access to find duplicates. So how to set up the sql when I don't have ID for the names. I could fix the database creating the ID, but sometimes the employer does not allow you to do it. When importing or copy and pasting large amount of rows of names, it's hard to spot duplicates. I know in Excel. but I want to know in Access. I want to see how many Mary Smith is repeating and show in another column(Duplicates) like 1(no duplicates) and the duplicates are, 2, 3, 4 and so forth. Why I need the numbers of duplicates, because I to highlight conditional formating to show any data that > 0 or and/or >1. Sometimes you don't want to see the duplicates separate, you want to see the duplicates together with the names not repeated like the 1 ones

[SK-wptm]

Your voice is very low please use a good mic