select -- top 100 id , count(*) [wut count ] from posthis...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select -- top 100
      id
      , count(*) [wut count ]
      -- , value
from posthistory
cross apply string_split(text, '<')
where posthistorytypeid = 6 
and len(value) > 0 
group by id
having count(*) > 5 
order by 2 desc 

select postid as [Post Link]
from posthistory
where posthistorytypeid = 6
and id in (320940, 19011, 17549)

Enter Parameters

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