0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who use Blender to create 3D graphics, animations, or games

SELECT TOP 100
    p.OwnerUserId AS UzivatelId,
    p.Id AS PostId,
    p.Title AS NazovPostu,
    p.ViewCount AS PocetZobrazeni
FROM Posts p
WHERE 
    p.CreationDate >= DATEADD(MONTH, -3, GETDATE()) 
    AND p.ViewCount > 0
ORDER BY p.ViewCount DESC;

fork query

edited aug 10

created aug 2 anonymous