查询前十条已经被采纳的标签中有mysql 的问题

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 10
  q.Id AS QuestionId,
  q.Title AS QuestionTitle,
  q.Body AS QuestionBody,
  a.Id AS AnswerId,
  a.Body AS AnswerBody
FROM
  Posts q
JOIN
  Posts a ON q.AcceptedAnswerId = a.Id
WHERE
  q.Tags LIKE '%mysql%'
  AND q.AcceptedAnswerId IS NOT NULL
ORDER BY
  q.CreationDate DESC;

Enter Parameters

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