dimanche 27 mars 2016

find values which are the same as value above in sqlite

I am trying to find values which are the same as at least two values above it. Please take a look.

id       number
1        2
2        6
3        7
4        7
5        7
6        1
7        2
8        4
9        7

So in this case select would return:

ID      NUMBER
3        7
4        7
5        7

Aucun commentaire:

Enregistrer un commentaire