transform row into col

[gin]

Hello,

I want to make a request like "transform access request".
I have a simple table with and unique id + a value between 1 to 20, and this
n times.
I want to create a table with id + 1 col and insert into the id and all the
value in one row.
Summary, I want to transform rows in cols... like a sumary report...
How can I do ( I don't have stored proc ;-((((( )

Thanks

[Aakash Bordia]

An example would be really helpful. I am slow, couldnt make sense out of
your note.
Thanks
Aakash

"gin" <gi*@wanadoo.fr> wrote in message
news:bn**********@news-reader1.wanadoo.fr...

Hello,

I want to make a request like "transform access request".
I have a simple table with and unique id + a value between 1 to 20, and this n times.
I want to create a table with id + 1 col and insert into the id and all the value in one row.
Summary, I want to transform rows in cols... like a sumary report...
How can I do ( I don't have stored proc ;-((((( )

Thanks

[gin]

This is a little exemple :

What I have :

table product
col product_name, col prix
product A, 1?
product A, 2?
product A, 3?
product B, 1?
product B, 4?
product C, 5?

I want :
Table summary:
col product_name, prix_summary
product A, 1?;2?;3?
product B, 1?;4?
product C, 5?

"Aakash Bordia" <a_******@hotmail.com> a écrit dans le message de
news:bn**********@hanover.torolab.ibm.com...

An example would be really helpful. I am slow, couldnt make sense out of
your note.
Thanks
Aakash

"gin" <gi*@wanadoo.fr> wrote in message
news:bn**********@news-reader1.wanadoo.fr...

Hello,

I want to make a request like "transform access request".
I have a simple table with and unique id + a value between 1 to 20, and

this

n times.
I want to create a table with id + 1 col and insert into the id and all

the

value in one row.
Summary, I want to transform rows in cols... like a sumary report...
How can I do ( I don't have stored proc ;-((((( )

Thanks

[Jacques Milman]

Try this :

with t(prod,prix,seq) as (
select prod
,prix
,rank() over (partition by prod order by prix) seq
from prod)
select prod
,sum(case when (seq=1) then prix else NULL end)
,sum(case when (seq=2) then prix else NULL end)
,sum(case when (seq=3) then prix else NULL end)
from t
group by prod
;

Jacques

"gin" <gi*@wanadoo.fr> wrote in message news:<bo**********@news-reader4.wanadoo.fr>...

This is a little exemple :

What I have :

table product
col product_name, col prix
product A, 1?
product A, 2?
product A, 3?
product B, 1?
product B, 4?
product C, 5?

I want :
Table summary:
col product_name, prix_summary
product A, 1?;2?;3?
product B, 1?;4?
product C, 5?

"Aakash Bordia" <a_******@hotmail.com> a écrit dans le message de
news:bn**********@hanover.torolab.ibm.com...

An example would be really helpful. I am slow, couldnt make sense out of
your note.
Thanks
Aakash

"gin" <gi*@wanadoo.fr> wrote in message
news:bn**********@news-reader1.wanadoo.fr...

Hello,

I want to make a request like "transform access request".
I have a simple table with and unique id + a value between 1 to 20, and this n times.
I want to create a table with id + 1 col and insert into the id and all the value in one row.
Summary, I want to transform rows in cols... like a sumary report...
How can I do ( I don't have stored proc ;-((((( )

Thanks