with base as (select distinct OwnerUserId,cast(creationDa...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Literature Meta

Q&A about the site for scholars and enthusiasts of literature

with base as (select distinct OwnerUserId,cast(creationDate as date) as ds from Posts where OwnerUserId>0)
--select OwnerUserId,ds,datediff(day,lag_ds,ds) as date_diff from 
select OwnerUserId, ds,lag(ds,1) over (partition by OwnerUserId order by ds) as lag_ds
from base

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results