SELECT TOP (2000) CASE WHEN Price - 44 > 125 THEN 'dayu' WHEN Price < 125 THEN 'xiaoyu' ELSE '' END AS ccccc
FROM m2c_PD_Style
关键就是:case when ___ then ___when___ then ___when___ then___……else ____as ___
SELECT TOP (2000) CASE WHEN Price - 44 > 125 THEN 'dayu' WHEN Price < 125 THEN 'xiaoyu' ELSE '' END AS ccccc
FROM m2c_PD_Style
关键就是:case when ___ then ___when___ then ___when___ then___……else ____as ___