mercredi 4 novembre 2015

SQLITE get row continous value

I have a simple table. One of the example rows looks like this:

id | name |
1  | a    |
2  | a    |
3  | a    |
4  | b    |
6  | b    |
7  | a    |
8  | a    |

I want to get last continuous id. so if i start at '1', the result should be '4'

in this example, the result should be '7'

3 |a |
4 |b |
5 |a |
6 |a |
7 |a |
10|a |

Only i now is that select all after my input number, and find continuous programmatically.

how can i do..?

Aucun commentaire:

Enregistrer un commentaire