根据条件选择差异值 [英] select diff values based on a condition

问题描述

大家好，

我需要选择一个不是来自数据库的字符串.我需要类似选择姓名，年龄，性别，级别=(如果点< = 499新手"，如果点> = 500专家")之类的东西在sql中如何处理?有可能吗?

谢谢!!

Hi all,

I need to select a string which is not from my db. i need something like select name, age, gender, level = (if points <= 499 ''newbie'', if points >= 500 ''expert'') how to this in sql? is it possible?

Thanks!!

推荐答案

所以你的意思是level不是一个字段?

在这一点上，您需要使用SELECT CASE语句来满足所需的输出.在这里，尝试一下:

So you mean level is not a field?

On this point, you need to use a SELECT CASE statement to meet your desired output. Here, try this:

SELECT     name
          ,age
          ,gender
          ,'level' = CASE
                         WHEN points <= 499 THEN 'newbie'
                         WHEN points >= 500 THEN 'expert'
                         ELSE 'unknown'
                     END
FROM      [TableName]

问候，
爱德华

Regards,
Eduard

这篇关于根据条件选择差异值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！