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

Lovely clear explanation - thank you very much!

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

Your voice is very low please use a good mic