2 agoni xiaoen agoni_xiaoen 于 2016.03.16 14:46 提问

case when sql语句问题
sql

当ACFLOW_ACCOUNTTYPE='0' AND (ACFLOW_BEFOREAVAILABLE < ACFLOW_AFTERAVAILABLE)的情况下ACFLOW_CHARGEAMOUNT as availableIncomeAmount
这sql语句怎么写?case when不能加as啊。。。

1个回答

sunyqcn
sunyqcn   2016.03.16 15:09
已采纳

case when ACFLOW_ACCOUNTTYPE='0' AND ACFLOW_BEFOREAVAILABLE < ACFLOW_AFTERAVAILABLE then ACFLOW_CHARGEAMOUNT end as availableIncomeAmount

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!