I think it's possible with CTE.
Recently I wondered whether it would be possible to implement an operation
that might be called "an accumulated group by". It's when you enumerate the
rows and based on the values of the previous row and current row you apply
some new "group" value that can be used
On Thu, 07 Dec 2017 19:46:21 +0100, nitpi...@arcor.de wrote:
> Hi all,
>
> I have a DB i.e. like this:
>
> table values
> bctemp
> 35123
> 35124
> 35123
> 20123
> 12123
> 12123
> 16123
> 35123
> 35123
> 35123
> 35123
> 35123
>
> The value in temp
ts.sqlite.org
>Subject: [sqlite] finding the number of records until a value is
>different
>
>Hi all,
>
>I have a DB i.e. like this:
>
>table values
>bc temp
>35 123
>35 124
>35 123
>20 123
>12 123
>12 123
>16 123
>
tpi...@arcor.de
Sent: Thursday, December 7, 2017 1:46 PM
To: sqlite-users@mailinglists.sqlite.org
Subject: [sqlite] finding the number of records until a value is different
Hi all,
I have a DB i.e. like this:
table values
bc temp
35 123
35 124
35 123
20 123
12
e-users@mailinglists.sqlite.org
Subject: [sqlite] finding the number of records until a value is different
Hi all,
I have a DB i.e. like this:
table values
bc temp
35 123
35 124
35 123
20 123
12 123
12 123
16 123
35 123
35 123
35 123
35
Hi all,
I have a DB i.e. like this:
table values
bc temp
35 123
35 124
35 123
20 123
12 123
12 123
16 123
35 123
35 123
35 123
35 123
35 123
The value in temp (or all the other columns) is not of interest.
Now I a looking for the
6 matches
Mail list logo