抓取其中一列中值为 true 的行

Question

>我的SQL Server 2016上有下表：

InvoiceNumber AutoPay        PaymentPlan
1234         Disabled          Active 
5678         Inactive           Completed
9123         Never Set Up       NULL
3456         Active             Cancelled

我正在尝试查找帐户上具有自动付款或付款计划的每个发票编号。

只要其中一列显示"活动"或"已完成"，我就希望查询显示该行。

结果：

InvoiceNumber     AutoPay        PaymentPlan
1234             Disabled          Active
5678             Inactive          Completed
3456             Active             Cancelled

Answer 1

我认为这就是你需要的：

SELECT InvoiceNumber
FROM myTable
WHERE AutoPay IN ('Active','Completed') OR PaymentPlan IN ('Active','Completed')

Answer 2

select * from tablename
where paymentplan IN ('Active','Completed') or autopay IN ('Active','Completed')

Answer 3

我认为下面会起作用

根据您的描述，您需要在查询中出现以下条件

select t.* from  t
where AutoPay IN ('Active','Completed') or
PaymentPlan in ('Active', 'Completed')

Answer 4

SELECT *
FROM [Invoice_Table]
WHERE [AutoPay] IN ('Active','Completed') OR [PaymentPlan] IN ('Active','Completed')
ORDER BY  [InvoiceNumber]

这就是我会使用的，但我不知道你的表的名称，所以在 FROM 行中换掉它。

干杯