0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

/** SELECT mainPosts.Id, mainPosts.Score FROM Posts as mainPosts
WHERE CreationDate > '2022-01-01 00:00:00'
and Score > 
(SELECT Score from Posts as Parent
WHERE mainPosts.ParentId = parent.Id)
ORDER BY mainPosts.Score DESC **/ 

SELECT mainPosts.Id, mainPosts.Score FROM Posts AS mainPosts
WHERE CreationDate > '2022-01-01 00:00:00'
AND Score > 
(SELECT Score From Posts AS Parent 
WHERE mainPosts.ParentId = Parent.Id)
ORDER BY mainPosts.Score DESC;

fork query

created dec 13 jon.doe40576