20160623 11:00
====================================================================
SELECT
reason,
category,
COUNT(*),
SUM(commdata)
FROM
tmpkk
GROUP BY
1,2
结果:
2016年劳动竞赛4月[分摊]找单摊(全车退保批单扣回) 962 -3986.01
---------------------------------------------------
SELECT
COUNT(*),
SUM(commdata)
FROM
tmpkk
WHERE
statdate >= '20160501'
AND statdate <= '20160531'
AND reason matches '*2016年劳动竞赛4月[分摊]找单摊(全车退保批单扣回)*' ;
结果:
(COUNT(*)) (SUM)
0 (NULL) -----------看吧。你想要的 结果没查到。
-----------------------------------------------------------------
SELECT
COUNT(*),
SUM(commdata)
FROM
tmpkk
WHERE
statdate >= '20160501'
AND statdate <= '20160531'
AND reason matches '*找单摊*' ;
结果:
(COUNT(*)) (SUM)
62 -3986.01
=================================================================
== 改掉tmpkk中的说明后,
=================================================================
SELECT
reason,
category,
COUNT(*),
SUM(commdata)
FROM
tmpkk
GROUP BY
1,2
结果:
2016年劳动竞赛4月(分摊)找单摊(全车退保批单扣回) 9 62 -3986.01
-------------------------------------------
SELECT
COUNT(*),
SUM(commdata)
FROM
tmpkk
WHERE
statdate >= '20160501'
AND statdate <= '20160531'
AND reason matches '*2016年劳动竞赛4月(分摊)找单摊(全车退保批单扣回)*' ;
结果:
(COUNT(*)) (SUM)
62 -3986.01 ----------这样就没问题了。。。
---------------------------------------------------------
SELECT
COUNT(*),
SUM(commdata)
FROM tmpkk
WHERE statdate >= '20160501' AND statdate <= '20160531'
AND reason matches '*找单摊*' ;
结果:
(COUNT(*)) (SUM)
62 -3986.01
==================================================================
==================================================================
综上结论:
informix数据库中,说明中尽量不使用[],而用英文状态下的()代替!!!
==================================================================
==================================================================