不知道重复纪录是不是就是指的Video_Name 重复,还有要得10条记录是消除重复以后的还是以前的纪录 select distinct Video_Name from ( select tdistinct Video_name, row_number() over (order by Video_time desc) rownum1 from table ) where rownum1 <=10
感觉楼上的没完全理解楼主的意思,按我的理解是: SQL> select * from tt_2;NAME S_DATE -------------------- -------------------- ssk 2005-5-15 15:50:58 ssk 2005-5-16 15:51:03 suk 2005-5-15 15:51:11 suk1 2005-5-17 15:51:16 suk2 2005-5-18 15:52:38 suk2 2005-5-12 15:52:546 rows selectedSQL> select * from (select name,max(s_date) from tt_2 group by name order by max(s_date) desc) where rownum<4;NAME MAX(S_DATE) -------------------- -------------------- suk2 2005-5-18 15:52:38 suk1 2005-5-17 15:51:16 ssk 2005-5-16 15:51:03
select distinct Video_Name from (
select tdistinct Video_name, row_number() over (order by Video_time desc) rownum1 from table )
where rownum1 <=10
SQL> select * from tt_2;NAME S_DATE
-------------------- --------------------
ssk 2005-5-15 15:50:58
ssk 2005-5-16 15:51:03
suk 2005-5-15 15:51:11
suk1 2005-5-17 15:51:16
suk2 2005-5-18 15:52:38
suk2 2005-5-12 15:52:546 rows selectedSQL> select * from (select name,max(s_date) from tt_2 group by name order by max(s_date) desc) where rownum<4;NAME MAX(S_DATE)
-------------------- --------------------
suk2 2005-5-18 15:52:38
suk1 2005-5-17 15:51:16
ssk 2005-5-16 15:51:03