oracle SQL语句

查找重复记录：

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