SQL Server 中的条件选择值

2021-09-10 00:00:00 sql tsql sql-server-2008 sql-server

在查询选择中，我想显示字段是否满足条件的结果.

In a query selection I would like to display the result whether a field satisfies a condition.

假设我有一个名为 stock 的表.这张表有一列告诉我库存中每件商品的数量.

Imagine that I have a table called stock. This table has a column that tells me the number of each item in the stock.

我想做的是这样的:

SELECT 
    stock.name, IF (stock.quantity <20, "Buy urgent", "There is enough")
FROM stock

SQL Server 中是否有任何函数可以做到这一点?

Is there any function in SQL Server to do that?

推荐答案

尝试案例

SELECT   stock.name,
      CASE 
         WHEN stock.quantity <20 THEN 'Buy urgent'
         ELSE 'There is enough'
      END
FROM stock

相关文章