Re: SQL BrainTeaser

Krisss,

SQL should like this one:

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

--
Best regards,
Diviner.




> 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