Q&A for users and developers of the Cardano cryptocurrency ecosystem
SELECT prev_Id, Id, diff, CreationDate FROM (SELECT *, LAG(Id) OVER(ORDER BY Id) as prev_Id, Id - LAG(Id) OVER(ORDER BY Id) as diff from PostsWithDeleted ) as t where t.diff > 1 ORDER BY prev_Id