Q&A for students, teachers, and linguists wanting to discuss the finer points of the Japanese language
/*SELECT a.* FROM ( SELECT c.* FROM COMMENTS AS c INNER JOIN ( SELECT answer.* FROM Posts AS question INNER JOIN Posts AS answer ON answer.ParentId = question.Id AND question.Tags LIKE '%spring%' --ORDER BY answer.ParentId ) as r ON c.POSTID = r.ID ) as a --offset 0 rows --fetch next 10 rows only; */ SELECT * FROM (SELECT ROW_NUMBER() OVER(ORDER BY a.Id) AS RowNum, * FROM ( SELECT c.* FROM COMMENTS AS c INNER JOIN ( SELECT answer.* FROM Posts AS question INNER JOIN Posts AS answer ON answer.ParentId = question.Id AND question.Tags LIKE '%spring%' --ORDER BY answer.ParentId ) as r ON c.POSTID = r.ID ) as a ) as alias WHERE RowNum BETWEEN 0 AND 100000