0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

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 0 ROWS
FETCH NEXT 100 ROWS ONLY;

view current version

edited sep 13

created sep 13 Shree.Guru.S