1.between语句:
mysql> select * from 4a where score between 76 and 89;
+--------+------+--------+------+--------+------+------+-------+
| sname | sage | tname | t | cname | s | c | score |
+--------+------+--------+------+--------+------+------+-------+
| 刘一 | 18 | 贺高 | 2 | 数学 | 1 | 2 | 78 |
| 钱二 | 19 | 叶平 | 1 | 语文 | 2 | 1 | 79 |
| 钱二 | 19 | 贺高 | 2 | 数学 | 2 | 2 | 81 |
| 张三 | 17 | 杨艳 | 3 | 英语 | 3 | 3 | 88 |
| 李四 | 18 | 贺高 | 2 | 数学 | 4 | 2 | 88 |
| 王五 | 17 | 杨艳 | 3 | 英语 | 5 | 3 | 78 |
+--------+------+--------+------+--------+------+------+-------+
6 rows in set (0.02 sec)
mysql> select * from 4a where score between 78 and 88;
+--------+------+--------+------+--------+------+------+-------+
| sname | sage | tname | t | cname | s | c