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自定义变量
日子过着过着就有了答案，努力走着走着就有了温柔的着落。