我目前正在与MySQL合作，创建一个视图，该视图将返回以下内容：
NAME | EMAIL | LAST_SEEN
abby | [email protected] | 2015-10-31 14:36:26
abby | [email protected] | 2015-11-28 13:30:37
然后我套用GROUP BY name到select query它返回以下
NAME | EMAIL | LAST_SEEN
abby | [email protected] | 2015-10-31 14:36:26
我想知道如何解决此查询，以便它返回以下内容：
NAME | EMAIL | LAST_SEEN
abby | [email protected] | 2015-11-28 13:30:37
实际代码如下：
CREATE VIEW v_user_last_seen
AS
SELECT concat_ws(' ', u.first_name, u.middle_name, u.last_name) AS user_name
,c.email
,l.in_when AS last_seen
FROM user AS u
INNER JOIN check_here_first AS c ON c.email = u.email
INNER JOIN log AS l ON l.u_id = c.username
GROUP BY user_name
ORDER BY user_name ASC
只需使用max（last_seen）
select name, email, max(last_seen)
from yourtable,
group by name, email;
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句