0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

WITH a AS (
    SELECT
        IIF(DATEDIFF(DD, LAG(CreationDate) OVER (ORDER BY CreationDate), CreationDate) > 20, 1, 0) AS [GroupNo],
        *
    FROM
        Posts p
    WHERE
        PostTypeId = 6
    )
SELECT
    SUM(GroupNo) OVER (ORDER BY CreationDate),
    *
FROM
    a
ORDER BY CreationDate;

view current version

edited mar 2

created mar 2 Henry.Ecker