SQLite Forum

Get column rank from values in selected row
Login
I think the easiest solution is to "tranpose" the table:
Centiles in column 1, field name Centile.
Ages as further field names.
Weights in table columns 2 till last.
I can then do:
Select centile from T where A3 = 9

RBS