借贷不平问题的处理

最新推荐文章于 2022-05-27 18:05:24 发布

hffah

最新推荐文章于 2022-05-27 18:05:24 发布

阅读量1.2k

点赞数

分类专栏：我的项目开发文章标签： date sql

本文链接：https://blog.csdn.net/hffah/article/details/2578873

版权

我的项目开发专栏收录该内容

3 篇文章 0 订阅

订阅专栏

select aae076, yab003, yad104, aad030, aae075, sum(yaa007)

  from (select aae076,

               yab003,

               yad104,

               aad030,

               aae075,

               decode(yaa009, '1', yaa007, -1 * yaa007) as yaa007

          from ad04a1

         where aae076 in ('100000167850956')

        union all

        select aae076,

               yab003,

               yad104,

               aad030,

               aae075,

               decode(aad032, '1', aad033, aad033 * -1) as yaa007

          from ad04

         where aae076 in ('100000167850956'))

 group by aae076, yab003, yad104, aad030, aae075

having sum(yaa007) != 0

 order by aae076, yab003, yad104, aad030, aae075;

借贷不平补充SQL功能还是比较爽的，学习。

----------------------------------------------------------

/*094098 2.2-3.31门诊个账借贷不平,请处理*/

//select  ykb053  from kb12k3 where  akb020='094098'

//and aae030 >= to_Date('2008-2-2 00:00:00','yyyy-mm-dd hh24:mi:ss')

//and yke151 <= to_date('2008-3-31 23:59:59','yyyy-mm-dd hh24:mi:ss');




// select *   from  kc24k1 where akc190 in(select akc190 from   kb03k9 where ykb053='21Y09409808041839549');




/*072290出现借贷不平现象，财务接口流水号：100000166121011



//select  *  from   kc32k1 where   aae076='100000166121011' and yad063='072290';



select  *       from  kc24k1 where akc190 in(

select  akc190  from  kc24k2 where ykb010 in(

select  ykb010  from  kb03k4 where aae075 in(


select  aae075  from  kc32k1 where aae076='100000166121011' and yad063='072290'))) ;