Query Users who has similar rating

index "users" has several columns

id(integer), name(string), rating(float)

e.g users
1 steve 3.3
2 jane 9.9
3 bob 2.3
4 taylor 5.5

when a user is given, (let's say {id:1 name:steve rating:3.3}
I want to query other people order by rating similar to steve
so result should be
1.bob 2.taylor 3.jane

how do I achieve this?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.