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)