Q&A for enthusiasts and power users of the Android operating system
WITH Raw AS ( SELECT Id, CreationDate, LAG(CreationDate) OVER (ORDER BY Id) AS PrevCreationDate FROM Votes ), Raw2 AS ( SELECT Id FROM Raw WHERE CreationDate < PrevCreationDate ) SELECT DISTINCT Votes.* FROM Votes, Raw WHERE Votes.Id BETWEEN Raw.Id - 10 AND Raw.Id + 10 ORDER BY Votes.Id DESC