检查列是否包含1 [英] Check whether a column contain 1

问题描述

您好我有以下SQL语句。我想检查返回的值是否包含1.我该怎么办？任何帮助，将不胜感激。以下是我的代码：

  SELECT  pd.IsSerialNumberMaskRequired 来自 ProductSetup.ProductVersion  as  pv 
  INNER   join  ProductSetup.ProductDetail  as  pd 
  on  pv.ProductHeaderId = pd.ProductHeaderId 
 其中 pv.ProductVersionId = '  24127' 

以上SQL语句返回4行记录，每行的值为1,1,0,1。

它有31，我该如何确定？

解决方案

尝试这样的事情：

  SELECT  count（pd.IsSerialNumberMaskRequired）˚F rom  ProductSetup.ProductVersion  as  pv 
  INNER  加入 ProductSetup.ProductDetail  as  pd 
  on  pv.ProductHeaderId = pd.ProductHeaderId 
 其中 pv.ProductVersionId = '  24127' 和 pd.IsSerialNumberMaskRequired =  1  
  group   by  pd.IsSerialNumberMaskRequired 

祝你好运！

 声明  @count   int  =  0  
 
 设置  @ coun ts  =（ SELECT  count（pd.IsSerialNumberMaskRequired）来自 ProductSetup.ProductVersion  as  pv 
  INNER   join  ProductSetup.ProductDetail < span class =code-keyword> as  pd 
  on  pv.ProductHeaderId = pd.ProductHeaderId 
  where  pv.ProductVersionId = '  24127' 和 pd.IsSerialNumberMaskRequired =  1  
  group   by  pd.IsSerialNumberMaskRequired）
 
 
  IF   @计数>  0  
 选择  1  

Hi I have the following SQL statement. I want to check whether the returned value contain 1. How can I do it? Any help would be appreciated. Below are my codes:

SELECT pd.IsSerialNumberMaskRequired from ProductSetup.ProductVersion as pv
INNER join ProductSetup.ProductDetail as pd
on pv.ProductHeaderId = pd.ProductHeaderId
where pv.ProductVersionId = '24127'

The above SQL statement return 4 rows of records with the value 1, 1, 0, 1 for each row.
It has 3 "1", how can I determine it?

解决方案

try something like this:

SELECT count(pd.IsSerialNumberMaskRequired) from ProductSetup.ProductVersion as pv
INNER join ProductSetup.ProductDetail as pd
on pv.ProductHeaderId = pd.ProductHeaderId
where pv.ProductVersionId = '24127' and pd.IsSerialNumberMaskRequired = 1
group by pd.IsSerialNumberMaskRequired

Good luck!

declare @counts int = 0

set @counts = (SELECT count(pd.IsSerialNumberMaskRequired) from ProductSetup.ProductVersion as pv
INNER join ProductSetup.ProductDetail as pd
on pv.ProductHeaderId = pd.ProductHeaderId
where pv.ProductVersionId = '24127' and pd.IsSerialNumberMaskRequired = 1
group by pd.IsSerialNumberMaskRequired)


IF @counts > 0
select 1

这篇关于检查列是否包含1的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！