select col1 , col2 , col3 , col4 from ( select col1 , col2 , col3 , col4 ,rank() over (partition by A.col2,A.col3 order by A.col4 asc) rk from A ) t where rk = 1
select * from 表A a,(select min(rowid) no from 表A group by 字段2,字段3) b where a.rowid=b.no;
select a.* from 表A a,(select min(rowid) no from 表A group by 字段2,字段3) b where a.rowid=b.no;
select a.* from 表A a,(select min(rowid) rowid from 表A group by f2,f3) b where a.rowid=b.rowid;
from
(
select col1 , col2 , col3 , col4 ,rank()
over (partition by A.col2,A.col3 order by A.col4 asc) rk
from A ) t
where rk = 1