Fastest-closed questions with 5 close votes

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

--Select Datediff(day, p.CreationDate, Current_Timestamp) 
--       as Age,
--       count(p.Id)

--From Posts p
--Group by Datediff(day, p.CreationDate, Current_Timestamp)
--Order by Datediff(day, p.CreationDate, Current_Timestamp) desc

select * from Posts where DateDiff(day, CreationDate, Current_Timestamp) = 2021
                    and   PostTypeId = 1

Enter Parameters

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