Aggregate rows in a Table
- From: Sasikumar<dearsas@xxxxxxxxxxxxxx>
- Date: Wed, 17 Oct 2007 21:14:13 GMT
Hi,
I have a Table with rows as below
A 1 10
B 1 15
A 2 3
A 1 5
A 3 10
Since the 1st & 4th row has values of A & 1 in first & second column, I wanted to aggregate the values in third colum. I wanted the result to be
B 1 15
A 2 3
A 1 15
A 3 10
How can this be done?
From http://www.developmentnow.com/g/108_2004_3_0_0_0/sql-server-mseq.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
.
- Follow-Ups:
- Re: Aggregate rows in a Table
- From: Hugo Kornelis
- Re: Aggregate rows in a Table
- Prev by Date: Re: Select without blank spaces
- Next by Date: Re: Aggregate rows in a Table
- Previous by thread: Re: Select without blank spaces
- Next by thread: Re: Aggregate rows in a Table
- Index(es):
