From: | Oliveiros <oliveiros(dot)cristina(at)gmail(dot)com> |
---|---|
To: | Claudio Adriano Guarracino <elninon(at)yahoo(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Select and merge rows? |
Date: | 2011-05-05 20:24:54 |
Message-ID: | BANLkTinDJXcVTJb5gCJtws+ma-M36EcjoA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Howdy!
Is there a maximum ceilling of three values per order ID? or an ID can have
an arbitrary number of values?
Best,
Oliveiros
2011/5/5 Claudio Adriano Guarracino <elninon(at)yahoo(dot)com>
> Hello!
> I have a doubt about a query that I tried to do, but I cant......
> This is the scenario:
> I have a table, with this rows:
> order ID value
> ----------------------
> 1 1000 3
> 2 1000 5
> 3 1000 6
> 1 1001 1
> 2 1001 2
> 1 1002 4
> 2 1002 4
>
> I need to get this table, divided by ID, like this:
> id value1 value2 value3
> --------------------------------
> 1000 3 5 6
> 1001 1 2
> 1002 1 2
>
> How I can do this?
> I tried with cursors and view, but i can't....
> Any help is welcome!
>
> Thanks in advance!
> Regards,
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Claudio Adriano Guarracino | 2011-05-05 20:53:02 | Select and merge rows? |
Previous Message | Claudio Adriano Guarracino | 2011-05-05 20:18:53 | Select and merge rows? |