mysql中加减乘除与求余和求平均值以及查询不等于某数值的实例(2)-木庄网络博客

当前第2页返回上一页

mysql> select score,avg(score) from 4a;
+-------+------------+
| score | avg(score) |
+-------+------------+
|    93 |    71.6364 |
+-------+------------+
1 row in set (0.00 sec)

4.mysql求不等于某数值操作：

mysql> select score,score!=88 from 4a;     
+-------+-----------+
| score | score!=88 |
+-------+-----------+
|    93 |         1 |
|    35 |         1 |
|    46 |         1 |
|    56 |         1 |
|    79 |         1 |
|    91 |         1 |
|    53 |         1 |
|    56 |         1 |
|    58 |         1 |
|    68 |         1 |
|    71 |         1 |
|    93 |         1 |
|    67 |         1 |
|    78 |         1 |
|    88 |         0 |
|    90 |         1 |
|    92 |         1 |
|    47 |         1 |
|    68 |         1 |
|    78 |         1 |
|    81 |         1 |
|    88 |         0 |
+-------+-----------+
22 rows in set (0.00 sec)