postes_sep_2021

0

Please login or register to vote for this query.

(click on this box to dismiss)

Russian Language

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

-- SELECT TOP 10 Body, Title, Tags
-- FROM Posts
-- WHERE YEAR(CreationDate)=2021
--   AND MONTH(CreationDate)=09 
--   AND Score>-1 
--   AND (PostTypeId=1 OR (PostTypeId=2 AND AcceptedAnswerId IS NOT NULL))

SELECT TOP 10 p1.Body, p1.Title, p1.Tags, p2.Body as Answer
FROM Posts p1
JOIN Posts p2 on p1.AcceptedAnswerId = p2.Id
WHERE YEAR(p1.CreationDate)=2021
     AND MONTH(p1.CreationDate)=09 
     AND p1.Score>-1 
     AND p1.PostTypeId=1 AND p1.AcceptedAnswerId IS NOT NULL
;

Enter Parameters

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