假如有这么一个表
+------+-------+--------------------------------------+
| id | val | field1 | field2 | |
+------+-------+--------------------------------------+
| 1 | 1 | ... | ... |
| 2 | 1 | ... | ... |
| 1 | 2 | ... | ... |
| 1 | 3 | ... | ... |
+------+-------+--------------------------------------+
我想得到按照id进行groupby之后val最大的行,结果为
+------+-------+--------------------------------------+
| id | val | field1 | field2 | |
+------+-------+--------------------------------------+
| 2 | 1 | ... | ... |
| 1 | 3 | ... | ... |
+------+-------+--------------------------------------+
这该如何操作?
下面的操作只能得到val的最大值,忽视了其他的字段,我需要整行的信息SELECT id, MAX(value) FROM my_table GROUP BY id
谢谢!