SQL to bunch rows together?

Due to new data designs, I need to bunch some rows in my table!

My table currently looks like this:

  column_a column_b column_c

• -------- -------- 1 abc 90 2 cdf 78 3 abc 100

Now the problem is that I have to go through the table and bunch all the data with the same value in column b. So my new table would look like:

  column_a column_b column_c

• -------- -------- 1 abc 190 2 cdf 78

How to handle this situation? About the column_a, well it is just an auto incremented internal ID and it can be managed with another sequence. But I need some help with SQL to bunch the rows with the same value in the column b! I dont mind having to create a temp table if needed.

I would appreciate any pointers/advice.

Thanks!

Sent via Deja.com
http://www.deja.com/ Received on Fri Feb 02 2001 - 22:10:58 CST