How does one find the second greatest value of each row (specific columns) of a MySQL table?
For eg, I have a table like the following,

```
| Game_no | Player_1 | Player_2 | Player_3|
|:--------|:---------|:---------|:--------|
| 1       | 2030     | NULL     | 120     |
| 2       | 1500     | 720      | NULL    |

```

I expect a result as,

```
| Game_no | Second_place_score|
|:--------|:------------------|
| 1       | 120               |
| 2       | 720               |

```

Null values exist, but there are no duplicates in the table.

Note that this only a representation, and in the original table, more than 2 (4, to be precise) players may have non-NULL values.