判断语句能用sql语句来表达嘛

[飞一龙]

IF(A1<5000,
A1*0.05,
IF(A1<=10000,A1*0.1-250,
IF(A1<=30000,A1*0.2-1250,
IF(A1<=50000,A1*0.3-4250,
IF(50000<=A1,A1*0.35-6750)))))

能用SQL表达出来嘛?

[正牌风哥]

case when A1 <5000 then A1*0.05 when ....then ...end

[正牌风哥]

有不确定因素时else， case when ....then .. when .. then .. else .. end

[dawugui]

case when

[dawugui]

case when A1 < 5000 then A1*0.05
     when A1 > 5000 and A1 <= 10000  then A1*0.1-250
     when A1 > 10000 and A1 <= 30000 then A1*0.2-1250
     when A1 > 30000 and A1 <= 50000 then A1*0.3-4250
     when A1 > 50000 then A1*0.35-6750
end 

[dawugui]

具体的>,>=,<,<=由你的数据而定.

[dmarkplus]

USE pubs
GO
SELECT   Category = 
      CASE type
         WHEN 'popular_comp' THEN 'Popular Computing'
         WHEN 'mod_cook' THEN 'Modern Cooking'
         WHEN 'business' THEN 'Business'
         WHEN 'psychology' THEN 'Psychology'
         WHEN 'trad_cook' THEN 'Traditional Cooking'
         ELSE 'Not yet categorized'
      END,
   CAST(title AS varchar(25)) AS 'Shortened Title',
   price AS Price
FROM titles
WHERE price IS NOT NULL
ORDER BY type, price
COMPUTE AVG(price) BY type
GO

[JL99000]

1 t_sql：用case when
2 如果用存储过程的话也可以用if else

[云中客]

case when /if else

[pt1314917]

用case