0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

-- Write a well-received answer to a question from a "New contributor"
-- The Q and the A must both have a positive score.

DECLARE @last datetime
SET @last = (SELECT create_date FROM sys.databases WHERE name = 'StackOverflow')
DECLARE @first datetime
SET @first = DATEADD(day, -7, @last)

SELECT min(q.id)
FROM Posts q
WHERE q.CreationDate > '2022-12-14'

fork query

edited dec 26

created dec 18 James.Risner