Number of comments thanking somebody

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

-- Number of comments thanking somebody

declare @totalcomments int
select @totalcomments = count(id) from comments

select
  'comments',
  count(Id) as [Count],
  count(Id) * 100.0 / @totalcomments as [Percentage]
from comments
where text like '%thank%';

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached