with base as (select distinct id,cast(creationDate as dat...

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 id,cast(creationDate as date) as ds from Posts)
select id, ds,lag(ds,1) over (partition by id order by ds desc) from base

Enter Parameters

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