[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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