mysql+mybaits根据goup by的查询

根据时间的前后排序

select b.bab062,oae300,oae001,a.bab302,a.bab303,a.aab998_zb,
a.bab304,a.aab998_js,a.bab305,
date_format(a.bab306,'%Y-%m-%d') bab306,//时间格式
a.bab307,a.aae013
from bb08 a,bb06 b  
where a.bab011 = b.bab011 and  b.aab001=#{aab001} 
order by a.aae418 desc//根据时间字段