-
Find duplicates - Unique IDs
Greetings -
I have a table as following:
lastname first name PermNO
x a 1
y b 2
z c 3
x a 1
x a 2
Wach person should have a unique PermNo. However due to bad data entry and not having the field specified as an ID, there are some people with more than one permNo., even though each person should have only one permno. For example, lastname "x", firstname "a", should always have his permno as 1, it should not be 2. The data above shows what I mean.
What I need is a query to list me all lastname, first name who have two or more PermNOs.
Thanks,
Lava
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
|
|