试试这个
select *
from test t
where not exists(
select 1
from test p
where t.rowid=max(rowid)
group by p.c1,p.c2,p.c3
)
select *
from test t
where not exists(
select 1
from test p
where t.rowid=max(rowid)
group by p.c1,p.c2,p.c3
)
select *
from test t
where not exists(
select 1
from test p
where t.rowid=max(rowid)
group by p.c1,p.c2,p.c3
)max函数那里有错误,提示信息是:ora-00934 group function is not allowed here.
select *
from test m
where m.rowid in (
select n.rowid
from test n
minus
select max(p.rowid)
from test p
group by p.c1,p.c2,p.c3
)
不知道会不会好一点,不在公司,没法测试……