如何计算唯一记录和其他记录使用SQL获取这些uniques和其他表中的数量？ [英] How to count unique records and other records get number of these uniques and other in table using SQL?

问题描述

如何计算唯一记录和其他记录使用SQL获取这些uniques和其他表中的数量？

这个我的查询

  SELECT  hubCode，mawb，ConfToInvoice，viaCode  FROM  tblViaDetails  WHERE  viaFlag = '  0'  AND  flDate = '  2013/07/04' 
 
  SELECT  COUNT（isConfirmed） AS  isConfirm  FROM  tblOutboundHeader  WHERE  isConfirmed = '  TRUE'  AND  viaCode = '  463' 
 
  SELECT  COUNT（isConfirmed） AS  isdisConfirm  FROM  tblOutboundHeader  WHERE  isConfirmed = '  FALSE'  AND  viaCode = '  463' 

我想要SELECT hubCode，mawb，viaCode，isConfirm，isdisConfirm因为我想绑定datagridview这个细节。



我试试这个

 选择计数（isConfirmed）  isConfirm 来自 tblViaDetails  INNER   JOIN  
 tblOutboundHeader  ON  tblViaDetails.viaCode = tblOutboundHeader.viaCode  group   by  isConfirmed 
 

无法选择hubCode，mawb，viaCode详情

解决方案

试试这个。

  SELECT  hubCode，
 mawb，
 viaCode，
 COUNT（ CASE  isConfirmed  WHEN  isConfirmed = '  TRUE'  AND  viaCode = '  463'  THEN   1   ELSE   NULL   END ）isConfirmed，
 COUNT（ CASE  isConfirmed  WHEN  isConfirmed = '  FALSE'  AND  viaCode = '  463' 那么  1   ELSE   NULL   END ）isdisConfirm 
  FROM  tblViaDetails 
  INNER   JOIN  
 tblOutboundHeader  ON  tblViaDetails.viaCode = tblOutboundHeader.viaCode 
 其中 viaFlag = '  0'  AND  flDate = '   2013/07/04' 
  group  按 isConfirmed 

U这样的事情

 选择 FK_DeviceID，DisplayOrder，IsActive 来自 tbl_Mst_Banner 
  union  
  select  COUNT（PK_BannerID），' ' DisplayOrder，'  ' IsActive 来自 tbl_Mst_Banner 
  union  
 选择 COUNT（FK_DeviceID），' '，' ' IsActive 来自 tbl_Mst_Banner 
  GROUP   BY  ImageLink 

How to count unique records and other records get number of these uniques and other in table using SQL?
This my Query

SELECT hubCode,mawb,ConfToInvoice,viaCode  FROM tblViaDetails WHERE  viaFlag='0' AND flDate='2013/07/04'

SELECT COUNT(isConfirmed) AS isConfirm  FROM tblOutboundHeader WHERE isConfirmed='TRUE'  AND viaCode='463'

SELECT COUNT(isConfirmed) AS isdisConfirm FROM tblOutboundHeader WHERE isConfirmed='FALSE' AND viaCode='463'

I want SELECT hubCode,mawb,viaCode,isConfirm,isdisConfirm Because i want to bind datagridview this details.

am try this one

Select count (isConfirmed) As isConfirm   from   tblViaDetails INNER JOIN
                tblOutboundHeader ON tblViaDetails.viaCode = tblOutboundHeader.viaCode  group by isConfirmed

can't select a hubCode,mawb,viaCode details

解决方案

Try this.

SELECT  hubCode,
    mawb,
    viaCode,
    COUNT(CASE isConfirmed WHEN isConfirmed='TRUE'  AND viaCode='463' THEN 1 ELSE NULL END) isConfirmed,
    COUNT(CASE isConfirmed WHEN isConfirmed='FALSE'  AND viaCode='463' THEN 1 ELSE NULL END) isdisConfirm
FROM    tblViaDetails
    INNER JOIN
    tblOutboundHeader ON tblViaDetails.viaCode = tblOutboundHeader.viaCode
where   viaFlag='0' AND flDate='2013/07/04'
group by isConfirmed

Use something like this

select FK_DeviceID,DisplayOrder,IsActive from tbl_Mst_Banner
union
select COUNT(PK_BannerID),'' DisplayOrder, ''  IsActive  from tbl_Mst_Banner
union
select COUNT(FK_DeviceID),'' ,'' IsActive from tbl_Mst_Banner
GROUP BY ImageLink

这篇关于如何计算唯一记录和其他记录使用SQL获取这些uniques和其他表中的数量？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！