0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for science fiction and fantasy enthusiasts

SELECT 
  q.Id AS QuestionId,
  q.Title AS QuestionTitle,
  q.Body AS QuestionBody,
  q.CreationDate AS QuestionCreationDate,
  q.Tags AS QuestionTags,
  q.AcceptedAnswerId,
  a.Id AS AnswerId,
  a.Body AS AnswerBody,
  a.CreationDate AS AnswerCreationDate,
  a.Score AS AnswerScore
FROM 
  Posts AS q
LEFT JOIN 
  Posts AS a
ON 
  q.AcceptedAnswerId = a.Id
WHERE 
  q.Tags LIKE '%<wso2>%'
ORDER BY 
  q.CreationDate DESC
OFFSET 2000 ROWS
FETCH NEXT 1000 ROWS ONLY;

view current version

edited sep 13

created sep 13 Shree.Guru.S