本文介绍了一条SQL查询语句，用于从jr_loan_channel_staterecodet表中筛选出特定渠道ID为9的状态记录，并排除了在jr_loan_channel_staterecode表中已存在的相同贷款ID、渠道ID和应用状态ID的记录。
select *
from jr_loan_channel_staterecode t
where t.channel_id = 9
and not exists (select *
from jr_loan_channel_staterecode
where loan_id = t.loan_id
and channel_id = 9
and apply_state_id = t.apply_state_id
and oper_time < t.oper_time)
order by oper_time
from jr_loan_channel_staterecode t
where t.channel_id = 9
and not exists (select *
from jr_loan_channel_staterecode
where loan_id = t.loan_id
and channel_id = 9
and apply_state_id = t.apply_state_id
and oper_time < t.oper_time)
order by oper_time
扫一扫
4497
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
