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
Webbo_1980Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
hyphenpipeConnect With a Mentor Commented:
select client_id, count(*) from table
 group by client_id
 having count(*) > 1
0
 
Bob HoffmanDeveloperCommented:
select a.* from table a
where (select count(*) from table b where b.clientId = a.clientId) > 1
0
 
hyphenpipeCommented:
Replace my client_id column name with your ClientID column name.
0
All Courses

From novice to tech pro — start learning today.