SQL select statement
- by kwokwai
Hi all,
I got a Table which has two fields: Point, and Level,
with some sample data as follows:
-----------------------
Point | Level
-----------------------
10 | Level 1
20 | Level 2
30 | Level 3
40 | Level 4
Suppose that there is a user who has 25 points,
to find the Level in which this user is in, the…