SELECT TOP 5 q.Id, q.CreationDate, q.OwnerUserId, q.Answe...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

SELECT TOP 5
    q.Id, 
    q.CreationDate,
    q.OwnerUserId,
    q.AnswerCount,
    q.ViewCount,
    q.CommentCount,
    q.FavoriteCount,
    q.Tags,
    q.Score,
	q.Title,
	q.Body,
	qh.PostHistoryTypeId,
	qh.Text
  FROM
    Posts q
	JOIN  
    PostHistory qh
    ON (q.Id = qh.PostId)
  WHERE
    q.PostTypeId = 1 AND -- Return questions
    q.ClosedDate IS NULL AND -- that hasn't been closed
	qh.PostHistoryTypeId in (1, 2, 3) -- and retrieving initial title, body and tags

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results