Who knows SQL?

[comp_sci_kid]

@bchad

It seems to me that maybe the answer is to load the full table into memory and do the addition in the code that receives the data from SQL, like Python, Java, or even C++. If you aren’t going to get a zillion rows, that may be your best solution.

That was my initial response, but I held back because if someone knew how to do it in SQL, I wanted to see how to do it.

I’ve relearned and forgotten SQL so many times I don’t know if I should be embarrassed, or proud…

No, the best way is to use metadata

http://en.wikipedia.org/wiki/Oracle_metadata

1. Find all columns (that is trivial using metadata)

2. Construct SQL statement. select sum(a1), sum(a2)… group by b1, b2. Also trivial once you know the group by column. Group by columns are fixed

3. Execute dynamic SQL to get result. All in all is pretty trivial.

[bchad]

Yes, that sounds pretty trivial. Is metadata now available in standard SQL, or is step zero, “migrate your database to Oracle?”

[former_trader]

@naren\_

@former_trader

You should have urbandictionary.com in your favorites when posting on this site.

No need to “lmgtfy” it.

I had to urbandictionary that one.