sql - SQL：有 MAX <> SUM

Question

这实际上是一个非常简单的查询，但我不知道为什么它向我显示 HAVING 实际排除的值。

---

表 1 -> 维护表

• ExpenditureComplete -> 浮动
• ID

表 2 -> 子表（Maintable 多于 1 个条目）

• 持续时间小时
• MainTable_ID（链接到 Table1 的 ID）
• ID

SELECT  
            a.ID, 
            b.MainTable_ID,
            MAX(a.ExpenditureComplete) as ExpenditureHours, 
            SUM(b.DurationHour) as DurationHours

    FROM [Table_1] as a
            Inner join
                [Table_2] as b
                    On
                        a.ID = b.MainTable_ID 

    Where a.Inactive = 0 
          and b.Inactive = 0

    Group by
                a.ID, 
                b.MainTable_ID

    Having MAX(a.ExpenditureComplete) <> SUM(b.DurationHour)

标签： sqlsummaxhavinghaving-clause

Answer 1

尝试这个：

Having ROUND(MAX(a.ExpenditureComplete),2) <> ROUND(SUM(b.DurationHour),2)