• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 486
  • Last Modified:

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
0
Webbo_1980
Asked:
Webbo_1980
  • 2
1 Solution
 
Bob HoffmanDeveloperCommented:
select a.* from table a
where (select count(*) from table b where b.clientId = a.clientId) > 1
0
 
hyphenpipeCommented:
select client_id, count(*) from table
 group by client_id
 having count(*) > 1
0
 
hyphenpipeCommented:
Replace my client_id column name with your ClientID column name.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now