Re: [ADMIN] Finding missing values in sequence column

2010-12-30 Thread Jasen Betts
On 2010-12-30, Lukasz Brodziak wrote: > Hello, > > I have a problem with writing a select statement that would return > records for which difference in values of this and following ID is > bigger than 1. Example table > ID Data > 1 Text > 2 Text2 > 5 Text5 > 23 Text23 >

Re: [ADMIN] Finding missing values in sequence column

2010-12-30 Thread Szymon Guz
On 30 December 2010 12:19, Lukasz Brodziak wrote: > Hello, > > I have a problem with writing a select statement that would return > records for which difference in values of this and following ID is > bigger than 1. Example table > ID Data > 1 Text > 2 Text2 > 5 Text5 > 23