Question

我有这样的 statement言:

select a.id, a.valfrom ...
  inner join ...
  where ...;

因此,我:

因此,你可以看到,一个人的补贴具有一个价值。

如果我由(a.id)组成一个小组,我会:

id    val
---------
 3     10
 9     21
11      2
13     30

What I want to get of the last result is the sum: 10+21+2+30 = 63.

So how can I get the sum as a single result? If I do a sum(a.val) and use group by (a.id) I do not get 63, I get the sum for every id, for example id=3 -> 10+10+10 = 30.

最佳方面。

Answer 1

那么,你就不需要一个小组。你们也可以在标准L.中正确选择身份证。你只是想:

www.un.org/Depts/DGACM/index_french.htm AS foo

但是,我的SQL支持将标准辛迪加的几处延伸到QQS公司,而MLI就是这样做的:

Answer 2

如果是,

select a.id, a.valfrom ...
  inner join ...
  where ...;

尝试:

select sum(distinct a.valfrom)
  inner join ...
  where ...;

没有任何“团体”倒下。

Answer 3

1. 采用分辨率和分辨率:

  select sum(valform) from (
    select distinct a.id, a.valfrom ...
    inner join ...
    where ...
  )

或使用组别:

  select sum(valform) from (
    select a.id, min(a.valfrom)
    inner join ...
    where ...
    group by a.id
  )

但我认为,第一个问题将会更快。

Answer 4

你只需要利用你必须做的记忆。

select ID,Sum(Distinct Val) 
from Table
Group By ID;

Answer 5

这将做到:

select a.id, a.valfrom, SUM(val) as mySum ...
  inner join ...
  where ...
GROUP BY NULL

友情链接