获得表某个分组的最大值

取得表某个分组的最大值select * from tablename a where a.createdate(select max(b.createdate) from t

取得表某个分组的最大值

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