请问根据日期筛选重复记录的有关问题，多谢

请教根据日期筛选重复记录的问题，谢谢
CODE NAME DATE
0001 AAA1 201001
0001 AAA2 201007
0002 BBB1 200902
0002 BBB2 201008

输入日期200907，结果如下
CODE NAME DATE
0001 AAA1 201001
0002 BBB2 201008



[解决办法]
貌似是取最小日期？

SQL code

create table t1 (CODE varchar2(20), NAME varchar2(10), t_date number(6));insert into t1 values ('0001','AAA1',201001);insert into t1 values ('0001','AAA2',201007);insert into t1 values ('0002','BBB1',200902);insert into t1 values ('0002','BBB2',201008);commit;select code,name,t_datefrom(select code,name,t_date,row_number() over(partition by code order by t_date) rnfrom t1where t_date >= 200907)where rn=1    code     name     t_date----------------------------------1    0001    AAA1    2010012    0002    BBB2    201008