查找重复记录:
select names,num
from test
where rowid != (select max(rowid)
from test b
where b.names = test.names and
b.num = test.num)
查找表TEST中时间最新的前10条记录:
select * from (select * from test order by dates desc) where rownum < 11
查找重复记录:
select names,num
from test
where rowid != (select max(rowid)
from test b
where b.names = test.names and
b.num = test.num)
查找表TEST中时间最新的前10条记录:
select * from (select * from test order by dates desc) where rownum < 11