select a.name01,a.date01,max(desc01) from yourtable a, ( select name01,max(date01) date01 from yourtable group by name01) b where a.name01=b.name01 and a.date01=b.date01 group by a.name01,a.date01
当然jiezhi兄比较好 select name01,date01,max(desc01) desc01 from table_name where (name,date01) in (select name,max(daet01) from table_name group by name) group by name,date01
from yourtable a,
( select name01,max(date01) date01 from yourtable
group by name01) b
where a.name01=b.name01 and a.date01=b.date01
group by a.name01,a.date01
select name01,date01,max(desc01) desc01
from table_name where (name,date01) in (select name,max(daet01) from table_name group by name) group by name,date01