Specific Group By query in SQL Server

initial table:

 1   1   3
 1   1   4
 1   2   1
 1   2   3
 2   1   5
 2   1   2
 2   2   2
 2   2   3

after group by on third column and sum on that column:

 1   1   7
 1   2   4
 2开发者_StackOverflow社区   1   7
 2   2   5

---

SELECT Col1, Col2, SUM(Col3)
FROM dbo.YourTable
GROUP BY Col1, Col2

Something like that??

---

Specify multiple columns to group by and it will only group when the values in all the columns are the same:

SELECT ColA, ColB, Sum(ColC) as Summation
FROM YourTable
GROUP BY ColA, ColB

---

    select one , two, sum(three)  from (
  select 1 as one, 1 as two, 3 as three from dual
  union
  select 1 as one, 1 as two, 4 as three from dual
  union
  select 1 as one, 2 as two, 1 as three from dual
  union
  select 1 as one, 2 as two, 3 as three from dual
  union
  select 2 as one, 1 as two, 5 as three from dual
  union
  select 2 as one, 1 as two, 2 as three from dual
  union
  select 2 as one, 2 as two, 2 as three from dual
  union
  select 2 as one, 2 as two, 3 as three from dual
) group by one, two;