I have a table called test. Its having data as below. I need to get each grouped highest numeric value from test table.

```
mysql> SELECT * FROM test;
+----+-------+------+
| id | value   | name  |
+----+-------+------+
|  1  |    1   | row1  |
|  2  |    1.2 | row2  |
|  3  |    1.5 | row3  |
|  4  |    2   | row4  |
|  5  |    3   | row5  |
|  6  |    3.1 | row6  |
|  7  |    3.6 | row7  |
|  8  |    4   | row8  |
|  9  |    5   | row9  |
|  10 |    5.1 | row10 |
+----+-------+------+
10 rows in set (0.00 sec)

```

But I need the result should be look like below to get maximum value in each number group:

```
+----+-------+------+
| id | value   | name  |
+----+-------+------+
|  1  |    1.5 | row1  |
|  4  |    2   | row4  |
|  7  |    3.6 | row7  |
|  8  |    4   | row8  |
|  10 |    5.1 | row10 |
+----+-------+------+
5 rows in set (0.00 sec)

```

Any one can help me ?How the query would be?