首先如下这样写是错的:
SELECT name,MAX(last_updated) FROM digital_asset GROUP BY name;
这样子查到的数据last_updated确实是最大的,但是和name没有关系;
用这个方法可以实现:
SELECT A.* FROM digital_asset A,
(SELECT name, max(last_updated) max_day FROM digital_asset GROUP BY name) B
WHERE A.name = B.name AND A.last_updated = B.max_day