17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT A.客户号, COUNT(1) 连续还款期数
FROM (SELECT A.客户号, A.还款日期
FROM 记录表 A, 记录表B
WHERE A.客户号 = B.客户号
AND TRUNC(ADD_MONTHS(A.还款日期, 1), 'MM') = TRUNC(B.还款日期, 'MM')) A
GROUP BY A.客户号
with tp as (
select 客户号,convert(varchar(7),还款日期,120)+'-01' as date from tb order by 客户号 date
),tp1 as (
select a.客户号,a.date from tp a join tb b on a.客户号=b.客户号 and datediff(month,a.date,b.date)=1
)
select a.客户号,count(0) 连续还款期数 from tp1 a group by a.客户号