SELECT TOP 2 q.Id AS [Question Link], a.Id AS [Answer Lin...

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 2
  q.Id AS [Question Link],
  a.Id AS [Answer Link],
  q.Title AS Question_Title,
  q.Body AS Question_Body,
  q.Tags AS Question_Tags,
  q.CreationDate AS Question_CreationDate,
  q.Score AS Question_Score,
  a.Body AS Answer_Body,
  a.CreationDate AS Answer_CreationDate,
  a.Score AS Answer_Score
FROM
  Posts q
JOIN
  Posts a ON q.Id = a.ParentId
WHERE
  (q.Tags LIKE '%<java>%')
  AND (q.PostTypeId = 1) -- 1 for questions
ORDER BY
  q.ViewCount DESC; -- Order by the number of views in descending order

Enter Parameters

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