0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for developers and researchers interested in open data

SELECT p.Title, p.CreationDate, p.ViewCount
FROM Posts p
WHERE p.CreationDate >= '01/01/2017'
AND p.ParentId=NULL
ORDER BY p.ViewCount DESC 
OFFSET 0 ROWS FETCH FIRST 10 ROWS ONLY

fork query

edited dec 13

created dec 13 anonymous