Results 1 to 2 of 2

Thread: Find duplicate of last name

  1. #1
    Anna Guest

    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.


  2. #2
    Janet McQuade Guest

    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
  •