sql - 添加新列并定义结果

Question

我有一个查询

SELECT *
 from  gp.db
 WHERE client ='paper'
 and packaging in ('Test1','Test2')
 and run_date  between  "07/01/21" and "07/03/2021"

这是结果：

我想要达到的目标：

1. 新栏目：“所有者”
2. 定义“包装列”中的任何 test1 和 test2 分别用于“所有者”列上的 Manager1 和 Manager2

最终结果：

标签： sqlsql-server

Answer 1

SELECT ff.packaging,ff.run_date,
 CASE
 WHEN ff.packaging='test1' then 'manager 1'
 when ff.packaging='test2' then 'manager 2'
 else 'manager 0'
  end as manager
 from  gp.db ff
 WHERE ff.client ='paper'
 and ff.packaging in ('Test1','Test2')
  and ff.run_date  between  "07/01/21" and "07/03/2021"