Search Postgresql Archives

Re: Group By question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 10/16/07, Jeff Lanzarotta <delux256-postgresql@xxxxxxxxx> 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)) ??

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux