How many duplicates have I found so far?

1

Please login or register to vote for this query.

(click on this box to dismiss)

https://meta.stackoverflow.com/q/397886/578411

Stack Overflow

Q&A for professional and enthusiast programmers

select hammertag
     , count(*) [#duplicates]
from
(
select JSON_value(text, concat(N'$.Voters[', value, N'].Id')) userid
     , JSON_value(text, concat(N'$.Voters[', value, '].BindingReason.GoldTagBadge')) hammertag
from posthistory ph
cross join string_split(N'0,1,2,3,4,5,6,7',',')
where ph.posthistorytypeid = 10 -- closed 
and comment in (1,101) -- duplicate close reasons
and JSON_value(text, concat(N'$.Voters[', value, N'].Id')) = '##userid:int?6574038##'
) data
group by hammertag

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results