SQL查询数据练习（2019上半年金融服务申请数据统计）-白红宇

SQL查询数据练习（2019上半年金融服务申请数据统计）

阅读量：5292 次

发布时间：2019-06-14

本文共 1443 字，大约阅读时间需要 4 分钟。

1.记录意向且拍卖成交的数据：

select row_number() over(order by LoanPreApply.CreateDate asc) as 序号,LoanPreApply.Proposer as '中标者',LoanPreApply.BidderNo as '中标号',LoanBank.BankName as '申请银行', LoanPreApply.CreateDate as '申请时间' from LoanPreApply,LoanBank where  LoanPreApply.BankId=LoanBank.BankId and LoanPreApply.CreateDate>'2019-01-01' and  LoanPreApply.CreateDate<'2019-07-01'

2.支付后分期柜面申请数据：

select row_number() over(order by LoanApply.ApplyTime asc) as 序号,LoanApply.Proposer as '中标者',LoanApply.BidderNo as '中标号',LoanBank.BankName as '申请银行', LoanApply.ApplyTime as '申请时间' from LoanApply,LoanBank where  LoanApply.BankId=LoanBank.BankId and LoanApply.ApplyType=1 and LoanApply.BusinessType=1 and  LoanApply.ApplyTime>'2019-01-01' and  LoanApply.ApplyTime<'2019-07-01'

3.所有申请表

select row_number() over(order by LoanApply.ApplyTime asc) as 序号,LoanApply.Proposer as '中标者',LoanApply.BidderNo  as '中标号',LoanBank.BankName as '申请银行',(case LoanApply.AcceptStatus when 1 then '已受理' else '未受理' end) as '受理状态',(case LoanApply.CheckStatus when 1 then '已通过' else '未通过' end) as '通过状态',(case LoanApply.PaymentStatus when 1 then '已打款' else '未打款' end) as '打款状态',(case LoanApply.MoneyCheckStatus when 1 then '已核账' else '未核账' end) as '核账状态',LoanApply.ApplyTime as '申请时间' from LoanApply,LoanBank where  LoanApply.BankId=LoanBank.BankId and  LoanApply.ApplyTime>'2019-01-01' and  LoanApply.ApplyTime<'2019-07-01'

转载于:https://www.cnblogs.com/yechangzhong-826217795/p/11127081.html

你可能感兴趣的文章

Java的值传递和引用传递

查看>>

HTML5的服务器EventSource(server-sent event)发送事件

查看>>

vue-devtools 获取到 vuex store 和 Vue 实例的？

查看>>

Linux 中【./】和【/】和【.】之间有什么区别？

查看>>

Ubuntu sudo 出现 is not in the sudoers file解决方案

查看>>