Vertical data to Horizontal data

[spider007]

Hi,

I have some data in rows which I want them in columns. Below is an
example:

col1 col2 col3
------ ----- -----
table length 45
table breadth 50
table height 60
chair length 15
chair breadth 25
chair height 20

I want this data in this format:
col1 length breadth height
----- -------- ---------- --------
table 45 50 60
chair 15 25 20

Can someone help in getting this o/p using SQL queries?
Thanks.

Saurabh

[The Boss]

spider007 wrote:

Hi,

I have some data in rows which I want them in columns. Below is an
example:

col1 col2 col3
------ ----- -----
table length 45
table breadth 50
table height 60
chair length 15
chair breadth 25
chair height 20

I want this data in this format:
col1 length breadth height
----- -------- ---------- --------
table 45 50 60
chair 15 25 20

Can someone help in getting this o/p using SQL queries?
Thanks.

Saurabh

What you are looking for is called a "Pivot Query", and the best description
for it is in a presentation "SQL On Fire" given by Serge Rielau during the
European IDUG 2006.
Check this blog-entry from Chris Eaton's blog where Chris gives an example
based on Serge's material:

http://blogs.ittoolbox.com/database/...ot-query-12757

In a comment to that blog-entry I've given links to the "SQL On Fire"
material (pivoting is in part 1, iirc).

HTH

Cheers!

--
Jeroen

[jefftyzzer]

On Jan 14, 10:30 am, "The Boss" <[e-mail]:

spider007 wrote:

Hi,

I have some data in rows which I want them in columns. Below is an
example:

col1 col2 col3
------ ----- -----
table length 45
table breadth 50
table height 60
chair length 15
chair breadth 25
chair height 20

I want this data in this format:

col1 length breadth height
----- -------- ---------- --------
table 45 50 60
chair 15 25 20

Can someone help in getting this o/p using SQL queries?
Thanks.

Saurabh

What you are looking for is called a "Pivot Query", and the best description
for it is in a presentation "SQL On Fire" given by Serge Rielau during the
European IDUG 2006.
Check this blog-entry from Chris Eaton's blog where Chris gives an example
based on Serge's material:

http://blogs.ittoolbox.com/database/.../pivot-query-1...

In a comment to that blog-entry I've given links to the "SQL On Fire"
material (pivoting is in part 1, iirc).

HTH

Cheers!

--
Jeroen

Serge's presentations are also available here:

http://www.iiug.org/waiug/present/Fo...Forum2006.html

in the "DB2 Performance Tuning and Administration" section

--Jeff

[spider007]

On Jan 15, 12:39 am, jefftyzzer <[e-mail]:

On Jan 14, 10:30 am, "The Boss" <[e-mail]:

spider007 wrote:

Hi,

I have some data in rows which I want them in columns. Below is an
example:

col1 col2 col3
------ ----- -----
table length 45
table breadth 50
table height 60
chair length 15
chair breadth 25
chair height 20

I want this data in this format:

col1 length breadth height
----- -------- ---------- --------
table 45 50 60
chair 15 25 20

Can someone help in getting this o/p using SQL queries?
Thanks.

Saurabh

What you are looking for is called a "Pivot Query", and the best description
for it is in a presentation "SQL On Fire" given by Serge Rielau during the
European IDUG 2006.
Check this blog-entry from Chris Eaton's blog where Chris gives an example
based on Serge's material:

http://blogs.ittoolbox.com/database/.../pivot-query-1...

In a comment to that blog-entry I've given links to the "SQL On Fire"
material (pivoting is in part 1, iirc).

HTH

Cheers!

--
Jeroen

Serge's presentations are also available here:

http://www.iiug.org/waiug/present/Fo...Forum2006.html

in the "DB2 Performance Tuning and Administration" section

--Jeff

Great! Thanks guys! Really appreciate your help.

-Saurabh