For posts that have more than 2 comments. Select all the text before the first period in the body co

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts Meta

Q&A about the site for enthusiasts and power users of the Android operating system

SELECT SUBSTRING(Text, 1, CHARINDEX('.', Text))
FROM Comments
JOIN Posts ON Comments.Id = Posts.Id
WHERE  CommentCount   > 2

Enter Parameters

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