0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for speakers of other languages learning English

SELECT preg.Id, preg.Title, preg.ViewCount
FROM Posts preg
WHERE preg.parentId IS NULL
AND preg.ViewCount = ( SELECT MAX(preg2.ViewCount)
FROM Posts preg2
WHERE preg2.parentId IS NULL);

fork query

edited sep 10

created sep 10 jon.doe44093