好记性不如写一遍,复习用
1:普通查询
SELECT
THIRDSYSTIME AS 交易时间,AMOUNT AS 交易金额,AUTHORCODE AS 交易码, FEE AS 手续费,SYSSERNO AS 系统跟踪号
FROM T_CPS_CUPSICACINFO;
2:筛选查询
SELECT
THIRDSYSTIME AS 交易时间,AMOUNT AS 交易金额,AUTHORCODE AS 交易码, FEE AS 手续费,SYSSERNO AS 系统跟踪号
FROM T_CPS_CUPSICACINFO
WHERE AMOUNT>=900.00
筛选查询主要有:
=【等于】
!=、<>【不等于】
>【大于】
<【小于】
>=【大于等于】
<=【小于等于】
3:特殊关键字筛选
Like【not like】;in【