Tsql如何正确使用HAVING功能 [英] Tsql how to use HAVING function properly

问题描述

你好专家，



我做了一个基于列的数学方程式，我只想得到值< 10和> 10.我尝试过使用但是它没有用。它仍然显示0值。



一个例子;





Thnx



我尝试过：

  SELECT   DISTINCT  
 ProjectNr，
 SUM（GWVS） -  SUM （GWVS2） AS  GWValue1，
 SUM（ABVS） -  SUM（GWVS2） AS  GWValue2， 
 SUM（TSVS） -  SUM（GWVS2） AS  GWValue2 
  FROM  TBL1 
  WHERE  RB  IN （北）
 
  GROUP   BY  ProjectNr 
 
  HAVING  
 SUM（GWVS） -  SUM（GWVS2）<> 

解决方案

如果您还要排除0值，然后你必须在你的查询：

  SELECT   DISTINCT  
 ProjectNr，
 SUM（GWVS） -  SUM（GWVS2） AS  GWValue1，
 SUM（ABVS） -  SUM（GWVS2） AS  GWValue2，
 SUM（TSVS） -  SUM（GWVS2） AS  GWValue2 
  FROM  TBL1 
  WHERE  RB  IN （北）
 
  GROUP   BY  ProjectNr 
 
  HAVING  
（SUM（GWVS） -  SUM（GWVS2））<>  10  
  AND （SUM（GWVS） -  SUM（GWVS2））<>  0  

您好，



检查这个......



SQL HAVING Clause [ ^ ]



希望这会对你有所帮助。



干杯

Hallo Experts,

I have done a mathematical equation based on columns and I want to only get the values < 10 and > 10. I have tried using Having but it isn't working. It still shows me the 0 values.

An Example;


Thnx

What I have tried:

SELECT DISTINCT 
 ProjectNr,
 SUM(GWVS) - SUM(GWVS2) AS GWValue1,
 SUM(ABVS) - SUM(GWVS2) AS GWValue2,
 SUM(TSVS) - SUM(GWVS2) AS GWValue2
FROM TBL1
WHERE RB IN (North)

GROUP BY ProjectNr

HAVING
SUM(GWVS) - SUM(GWVS2) <>10

解决方案

If you want to exclude 0 values also, then you have to provide this constraint in your query:

SELECT DISTINCT 
 ProjectNr,
 SUM(GWVS) - SUM(GWVS2) AS GWValue1,
 SUM(ABVS) - SUM(GWVS2) AS GWValue2,
 SUM(TSVS) - SUM(GWVS2) AS GWValue2
FROM TBL1
WHERE RB IN (North)
 
GROUP BY ProjectNr
 
HAVING
 (SUM(GWVS) - SUM(GWVS2)) <> 10
 AND (SUM(GWVS) - SUM(GWVS2)) <> 0

Hi,

Check this...

SQL HAVING Clause[^]

Hope this will help you.

Cheers

这篇关于Tsql如何正确使用HAVING功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！