select 城市,人口,max(创建时间) from table group by 城市;
select id,城市,人口,信息,max(时间戳) from table group by 城市
思路:先用子查询根据城市分组得出每个城市最新的城市和创建时间,再用内联的方式显示完整的记录。
答:SELECT c1.* FROM city AS c1 INNER JOIN (SELECT city,MAX(createtime) AS createtime FROM city GROUP BY city) AS c2 ON c1.city=c2.city AND c1.createtime=c2.createtime;
max group by
这道题你会答吗?花几分钟告诉大家答案吧!
扫描二维码,关注牛客网
下载牛客APP,随时随地刷题