paip.检测信用卡账单数据的正确性算法

paip.检测信用卡账单数据的正确性算法

主要3点:
//1.重点检测.大钱记录
//2.检测遗漏记录
//3.排除双唇记录.
//4.试着cls share,改变错误的cls.


作者Attilax 艾龙， EMAIL:1466519819@qq.com
来源：attilax的专栏
地址：http://blog.csdn.net/attilax

///重点检测.大钱记录

select * from cyar2013 where moneyx>300 order by datex,moneyx

//检测遗漏记录
一个好方法,就是生成趋势图片..一挂走看出来不对的月份..然后..

//2.检测是否有卡片遗漏..(11g)..单个的月份
SELECT
    *
FROM
    cyar2013
WHERE
    MONTH (datex) = 7
AND YEAR (datex) = 2013
AND acc != "alipay"
AND acc != "cash"
AND acc IS NOT NULL
AND cls != 'insure'
AND cls != 'mkt'
AND cls != 'o'
AND cls != 'other'
AND cls NOT LIKE 'POS%'
ORDER BY
    acc
    
///查看信用卡多个月份的趋势..
SELECT
    *
FROM
    cyar2013
WHERE
    ( MONTH (datex) >=2 and     MONTH (datex) <=3
AND YEAR (datex) = 2013 )
AND acc != "alipay"
AND acc != "alip"
AND acc != "cash"
AND acc IS NOT NULL
and acc !='un'
AND cls != 'insure'
AND cls != 'mkt'
AND cls != 'o'
AND cls != 'other'
AND cls NOT LIKE 'POS%'
and (cls='int' or cls='itrst' or cls='fcssf' or cls='ckssf')

查看单张卡片的记录
SELECT
    *
FROM
    cyar2013
 where acc like '%hs%' or acc like 'yp'
order by datex

///排除双唇记录.
select * from cyar2013 where month(datex)>6 and ( cls='mkt' or cls='o' or cls='other' or demo like 'ka%') order by datex,moneyx