取得表某个分组的最大值

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