取得表某个分组的最大值 博客分类： sql语句oracle

select * from tablename a where a.createdate=(select max(b.createdate) from tablename b where a.channel=b.channel)