Webbo_1980
asked on
How do i find duplicate guid values
Hi
Is there a way for me to return me to find duplicate unique identifiers in a table.
So for example say we have the the following fields in a table i.e. ID, ClientID, Name
Lets say ClientId is a unqiueIdentifer and i want to return all clientids which are contained in the table more than once?
Thanks
Webbo
Is there a way for me to return me to find duplicate unique identifiers in a table.
So for example say we have the the following fields in a table i.e. ID, ClientID, Name
Lets say ClientId is a unqiueIdentifer and i want to return all clientids which are contained in the table more than once?
Thanks
Webbo
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Replace my client_id column name with your ClientID column name.
where (select count(*) from table b where b.clientId = a.clientId) > 1