Skip to content

Instantly share code, notes, and snippets.

@abhisheksoni27
Created November 15, 2018 08:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save abhisheksoni27/932a4507b47ec9b8a89e97b0b01f39f8 to your computer and use it in GitHub Desktop.
Save abhisheksoni27/932a4507b47ec9b8a89e97b0b01f39f8 to your computer and use it in GitHub Desktop.
SELECT
p.Id,
c.Text
FROM
[sotorrent-org:2018_09_23.Posts] p
INNER JOIN
[sotorrent-org:2018_09_23.Comments] c
ON
p.Id = c.PostId
WHERE
-- p.PostTypeId = 2
-- AND p.Tags LIKE '%java%'
p.Id IN (
SELECT
Id
FROM
[sotorrent-org:2018_09_23.Posts]
)
LIMIT 100
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment