dimanche 13 mars 2016

SQLite Maximum matching row by multi column with value

test table

ID  a   b   c   d   e   f   to  z

0   2   7   9   0   8

1   4   5   6   3   0

2   1   5   6   2   9

3   1   0   8   2   3

4   2   1   6   9   5

5   1   5   6   2   3

6   2   3   4   1   0

maximum matching and sorting from this query - select ID from test where a = 1, b = 5, c = 6, d = 2, e = 3, f to z

output: 5, 2, 3, 1, 4

query ??? please help...

Aucun commentaire:

Enregistrer un commentaire