0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

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 '%<postman>%'
ORDER BY 
  q.CreationDate DESC
OFFSET 10000 ROWS
FETCH NEXT 5000 ROWS ONLY;

fork query

edited sep 13

created sep 13 Shree.Guru.S