select * from tablename a where a.createdate=(select max(b.createdate) from tablename b where a.channel=b.channel)
取得表某个分组的最大值
最新推荐文章于 2021-04-02 22:26:16 发布
select * from tablename a where a.createdate=(select max(b.createdate) from tablename b where a.channel=b.channel)