select a.field0,max(a.field1),max(a.field1),max(a.field3)
from Table a, (select distinct field0
from Table ) b
where a.field0=b.field0
group by a.field0
from Table a, (select distinct field0
from Table ) b
where a.field0=b.field0
group by a.field0
where rowid in
(select max(rowid) from tabname group by field0 );
where rowid <(select max(rowid) from tablename b
where b.field0=a.field0
and b.field1=a.field1
and b.field2=a.field2)