How to transform table rows into Colum?
От | Eric Ndengang |
---|---|
Тема | How to transform table rows into Colum? |
Дата | |
Msg-id | 4D77B5FC.6010502@affinitas.de обсуждение исходный текст |
Ответы |
Re: How to transform table rows into Colum?
Re: How to transform table rows into Colum? |
Список | pgsql-sql |
Hi Guys, I have the following table: Name Value rang salary ------------------------------------ name1 value1 1 2500 name2 value2 2 2600 name3 value 3 3 300 and want to obtain the following result: name1 name2 name3 ------------------------------------ value1 value2 value3 1 2 3 2500 2600 300 what should i do ? I read about the crosstab function in postgresql but still have no idea on how to use it to solve this problem. Any help would be appreciated Regards -- Eric Ndengang Datenbankadministrator Affinitas GmbH | Kohlfurter Straße 41/43 | 10999 Berlin | Germany email: eric.ndengang_foyet@affinitas.de | tel: +49.(0)30. 991 949 5 0 | www.edarling.de Geschäftsführer: Lukas Brosseder, David Khalil, Kai Rieke, Christian Vollmann Eingetragen beim Amtsgericht Berlin, HRB 115958
В списке pgsql-sql по дате отправления: