On 10/16/07, Jeff Lanzarotta <delux256-postgresql@yahoo.com> wrote:
> Hello,
>
> I have a table that looks something like this:
>
> SKU Dept Col1 Col2 Col3
> ------- ------ ------- ------- ------
> 1 1 1 2 3
> 2 1 2 3 4
> 3 2 1 0 1
> 4 2 0 1 2
> 5 2 4 1 3
> 6 3 1 2 3
>
> I am having a problem trying to get the Is there a query that can do
> something like this:
>
> select sku, dept, (col1 + col2) * col3) from table group by dept
So, what would the output look like?
For instance, you've got these two lines at the top:
SKU Dept Col1 Col2 Col3
------- ------ ------- ------- ------
1 1 1 2 3
2 1 2 3 4
If we group by dept, then how do I handle those two rows? Which SKU
would be the right one? Would the answer be
((sum(col1)+sum(col2))*sum(col3)) ??