-
Find duplicate of last name
Hello eveyone,
How can I query to find and list the duplicates of any last name in a database.
Thanks and regards,
Anna.
-
How about using having/group by
e.g
select Name, count(*) from TABLE group by Name having count(*) > 1
Janet
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|