34,590
社区成员
发帖
与我相关
我的任务
分享
SELECT exp1 = (CASE WHEN [成交价] / [零售限价] * 100 = 100 THEN '100' ELSE ' 90' end)
from xxxx
SELECT exp1 = (CASE WHEN [成交价] = [零售限价] THEN '100' ELSE ' 90' end)
from xxxx
SELECT exp1 = CASE WHEN [成交价] / [零售限价] * 100 = 100 THEN '100' ELSE ' 90' emd
from xxxx
SELECT exp1 = CASE WHEN [成交价] / [零售限价] * 100 = 100 THEN '100' ELSE ' 90' end
from xxxx
CASE WHEN xxx=xxx THEN xx ELSE xx END