如下表:表名A,数据如下
name ver
a001 v1.0
b002 v1.1
b002 v1.0
a001 v1.3
b002 v1.3
a001 v1.2
b002 v1.2想得到每个名称下的最新版,如下:、
name ver
a001 v1.3
b002 v1.3请问应该如何写?
name ver
a001 v1.0
b002 v1.1
b002 v1.0
a001 v1.3
b002 v1.3
a001 v1.2
b002 v1.2想得到每个名称下的最新版,如下:、
name ver
a001 v1.3
b002 v1.3请问应该如何写?
from A
group by name
+------+------+
| name | ver |
+------+------+
| a001 | v1.0 |
| b002 | v1.1 |
| b002 | v1.0 |
| a001 | v1.3 |
| b002 | v1.3 |
| a001 | v1.2 |
| b002 | v1.2 |
+------+------+
7 rows in set (0.00 sec)mysql> select name,max(ver) as ver
-> from A
-> group by name;
+------+------+
| name | ver |
+------+------+
| a001 | v1.3 |
| b002 | v1.3 |
+------+------+
2 rows in set (0.00 sec)mysql>