IF X , A , B and C are lists
X = [ A ,B, C]
A = [ R ,T ,9]
B = [ Q, X, 7]
C = [ S ,D ,15]
How to arrange X elements due to numbers in A,B and C
Note : X after arranging suppose to be X = [ C, A,B]
put your data into the sqlite database like this
Col1,Col2,Col3,Col4
A, R , T, 9
B, Q, X, 7
C, S, D , 15
and use a select statement like this
SELECT Col1 FROM myTable ORDER BY Col4 DESC
Taifun
2 Likes