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
Ideas?
-Jeff