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
相关文章
- 12-17paip.检测信用卡账单数据的正确性算法