mysql中聚合函数不能_我可以在mysql中使用聚合函数（LAST）吗？

can i use aggregation function (LAST) in mysql??

if yes then why give me error for following query::

SELECT `user_id`,last(`value`)

FROM `My_TABLE`

group by `user_id`

ERROR:: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(value) FROM My_TABLE group by user_id' at line 1

EDIT:: I got answer "last" is not used in MySql. then How to perform it in MySql??

解决方案

No, There is nothing called LAST in mysql

EDIT

You can perform the same something like this

select f.user_id, f.value

from (

select MAX(value) as maxval

from my_table group by user_id

) as x inner join my_table as f on f.value = x.maxval