17,377
社区成员
发帖
与我相关
我的任务
分享
select member_id,result,max(record_date)
from test
group by member_id,result;
select MEMBER_ID, RESULT, RECORD_DATE
from (select MEMBER_ID,
RESULT,
RECORD_DATE,
row_number() over(partition by MEMBER_ID order by RECORD_DATE desc) rn
from test1)
where rn = 1;
select * from test11
where record_date in(
select max(record_date) from test11 t
group by member_id
)
SQL> SELECT *
2 FROM TEST T1
3 WHERE NOT EXISTS (
4 SELECT 1
5 FROM TEST T2
6 WHERE T1.MEMBER_ID = T2.MEMBER_ID
7 AND T1.RECORD_DATE < T2.RECORD_DATE
8 );
MEMBER_ID RESULTS RECORD_DATE
---------- ---------- -----------
1 24 9/1/2003
2 15 8/8/2008
3 15 8/1/2008
SQL>