0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in conceptual questions about life and challenges in a world where "cognitive" functions can be mimicked in purely digital environment

SELECT top 6000
    q.Id AS QuestionId,
    q.Title AS QuestionTitle,
    q.Body AS QuestionBody,
    a.Id AS AnswerId,
    a.Body AS AnswerBody,
    a.Score as Score
FROM 
    Posts q
JOIN 
    Posts a ON q.AcceptedAnswerId = a.Id
WHERE 
    q.PostTypeId = 1 -- Perguntas
    AND a.PostTypeId = 2 -- Respostas
    AND q.AcceptedAnswerId IS NOT NULL -- Perguntas com respostas aceitas

fork query

edited feb 25

created feb 25 anonymous