Re: SQL BrainTeaser

From: jAnO! <j.j.groot_at_kpn.com>
Date: 21 Jun 2001 09:17:39 GMT
Message-ID: <01c0fa33$044c01a0$142b15ac@TONTW0102131521>

Krisss <kmbotha_at_netinfo.ubc.ca> schreef in artikel <3b31b734.187723645_at_news.interchange.ubc.ca>...
> Hi all,
>
> Using Oracle, I'm trying to analyze a table of the form:
>
> id1 id2 value
> ---------------------------------
> aa a1 4
> bb a2 3
> cc a1 6
> dd a3 8
> ee a4 10
> ff a4 10
>
> What I'd like to do is combine rows that have the same id2 (by summing
> their value). i.e. I want to get is THIS table:
> id2 value
> ------------------------------
> a1 10
> a2 3
> a3 8
> a4 20
>
> any ideas on how I should go about this using SQL??
>
> Thanks
> ~~====----..----====~~
> Kris Botha
>
>

select id2, sum(value) from table
group by id2;

hth

Jan Received on Thu Jun 21 2001 - 04:17:39 CDT