questions by first word in the title

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

DECLARE @FirstWords TABLE (Word NVARCHAR(250))
INSERT @FirstWords
SELECT
    Substring(Title, 1, CharIndex(' ', Title))
FROM Posts
WHERE PostTypeId = 1


SELECT TOP 100
  Word,
  Count(*) AS [Count]
FROM @FirstWords
GROUP BY Word
ORDER BY Count(*) DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results