Error querying SQL Server

Question

This is my table

create table #t(id int, amt int)

insert into #t values(1, 40), (1, 20), (1, 10), (2, 100), (2, 120), (2, 400)

I need output like this!

I tried

SELECT
    id, SUM(amt) 
FROM
    #t 
GROUP BY
    id

vhadalgi · Accepted Answer · 2014-02-12 09:37:53Z

3

Try This !

select id,sum(amt) over(partition by id) as amt from #t

answered Feb 12, 2014 at 9:37

vhadalgi

7,2376 gold badges44 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andomar · Accepted Answer · 2014-02-12 09:38:02Z

2

select  id
,       sum(amt) over (partition by id)
from    #t

answered Feb 12, 2014 at 9:38

Andomar

239k55 gold badges387 silver badges412 bronze badges

@ta.speot.is: I think SQL Server 2008 and later

Vikram Jain · Accepted Answer · 2014-02-12 09:56:39Z

1

select a.id, c.amt from #t as a
left outer join 
(SELECT b.id, SUM(b.amt) as amt FROM   #t as b  GROUP BY  id ) as c on c.id=a.id

answered Feb 12, 2014 at 9:56

Vikram Jain

5,6081 gold badge22 silver badges31 bronze badges