0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

SELECT Q.Id, Q.Body, A.Id, A.Body
  FROM (
    SELECT TOP 10 * FROM Posts
    WHERE PostTypeId = 1 and
          Body LIKE '%<code>%' and
          AcceptedAnswerId != ''
          ORDER BY Rand()
    ) Q
  JOIN Posts as A
    ON Q.AcceptedAnswerId = A.Id;

view current version

edited dec 3

created dec 3 Brandon.Wong