计算机网络/计算机科学与应用/系统/运维/开发

SQL语句中使用用户自定义变量


mysql> select * from salary;
+------------+---------+---------+
| employeeID | income  | outcome |
+------------+---------+---------+
| 000001     |  2100.8 |   123.9 |
| 010008     | 1582.62 |   88.03 |
| 020010     |    2860 |     198 |
| 020018     | 2347.68 |     180 |
| 102201     | 2569.88 |  185.65 |
| 102208     |    1980 |     100 |
| 108997     | 3259.98 |  281.52 |
| 111006     | 1987.01 |   79.58 |
| 210678     |    2240 |     121 |
| 302566     |  2980.7 |   210.2 |
| 308759     | 2531.98 |  199.08 |
| 504209     | 2066.15 |     108 |
+------------+---------+---------+


mysql> select @count := max(income+outcome) from salary;
+-------------------------------+
| @count := max(income+outcome) |
+-------------------------------+
|             3541.499969482422 |
+-------------------------------+
1 row in set, 1 warning (0.01 sec)


mysql> select * from salary where  income+outcome = @count;
+------------+---------+---------+
| employeeID | income  | outcome |
+------------+---------+---------+
| 108997     | 3259.98 |  281.52 |
+------------+---------+---------+
1 row in set (0.00 sec)


sql 自定义变量

日子过着过着就有了答案,努力走着走着就有了温柔的着落。

评论

^