表结构呢,按人员分组,按日期排序取第一条记录假设你的表结构是这样的: tableA userid,xfdate,xfmoneyseect userid,xfdate,xfmoney from( select userid,xfdate,xfmoney,row_number() over(partition by userid order by xfdate) rn from tableA) where rn=1
我帮你加上 seect userid,xfdate,xfmoney from( select userid,xfdate,xfmoney,row_number() over(partition by userid order by xfdate) rn from tableA where to_char(xfdate,'yyyy-mm') between '2009-01' and '2009-06') where rn=1;
row_number() over(partition by userid order by xfdate) 這個事關鍵代碼.
tableA
userid,xfdate,xfmoneyseect userid,xfdate,xfmoney
from(
select userid,xfdate,xfmoney,row_number() over(partition by userid order by xfdate) rn
from tableA) where rn=1
我帮你加上
seect userid,xfdate,xfmoney
from(
select userid,xfdate,xfmoney,row_number() over(partition by userid order by xfdate) rn
from tableA
where to_char(xfdate,'yyyy-mm') between '2009-01' and '2009-06')
where rn=1;
row_number() over(partition by userid order by xfdate) 這個事關鍵代碼.