Re: rotation table in 90 degree - help

Hi!
My Idea would be to make a select which groups the table after PK, with a count on it, select the max of it, and then create the view with decode and that number of columns; Just an Idea, didnīt try if this could work!

Alex

ori <ori_m57_at_hotmail.com> schrieb in im Newsbeitrag: 479fe5cd.0202150035.1819a96b_at_posting.google.com...
> Hi,
>
> I need to create a view that looks like a 90 degree
rotation of the
> original table.
> for example: say my table looks like:
> A B
> 1 100
> 2 500
> 3 150
> 2 300
> 2 350
> 1 200
>
> then my view should look something like:
> 1 100 200
> 2 500 300 350
> 3 150
>
> I cant know how many rows in the table contain the same A
data.
> can I create a view like this?
>
> thanks alot
> Ori
Received on Fri Feb 22 2002 - 02:56:35 CST