select a.* from q_jjjl a where a.ywdate = (select max(ywdate) from q_jjjl where dwdm=a.dwdm) order by a.dwdm ASC