0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT SUBSTRING(Body, PATINDEX('%http://*.tryitonline.net', Body) + 7, CHARINDEX('.', Body, PATINDEX('%http://*.tryitonline.net', Body)) - PATINDEX('%http://*.tryitonline.net', Body) + 6) AS Language, COUNT(*) AS Frequency FROM Posts
WHERE PostTypeId = 2
GROUP BY SUBSTRING(Body, PATINDEX('%http://*.tryitonline.net', Body) + 7, CHARINDEX('.', Body, PATINDEX('%http://*.tryitonline.net', Body)) - PATINDEX('%http://*.tryitonline.net', Body) + 6);

fork query

edited jul 2 16

created jul 2 16 LegionMammal978