Re: Challenge!! Crack it if you are a man!!

the guy is an obvious jerk, but jerks need help too. Buddy, be nice and peole will help you out right away be a jerk and get liitle help.

You need to denormaize your orginal table. I wouldn't give you the SQL for being a jerk. i asked the exact same question, got several responses in a few hours.

but here is hint, use DECODE, no need for joins and it is doable in one statement.

In article <37348614_at_discussions>, "Sanjaya Ganesh" <sganesh_at_apple.com> wrote:
>
>Hi ,
>
> I have the following requirement in
>Oracle 7.3, please note ORACLE 7.3!!
>
> I have a table with primary key
>columna and columnb. For a given value of
>columna ,there can be 6 different values of
>columnb and this 6 is fixed. I want a view
>which will stretch and flatten this table.
>That is I want a view which will show me in
>ONE ROW
>
>columna and the 6 different values of columnb.
>
>i.e., Table is,
>
>columna colb1
>columna colb2
>columna colb3
>columna colb4
>columna colb5
>columna colb6
>
>I want a view which will represent it as,
>columna colb1 colb2 colb3 colb4 colb5 colb6
>
>It is real challenge, because I dont want a 6-
>way join!!!Hahaha!!! I know how to do with a 6
>way join!!I dont want that!!
>
>Any real men around??
>
>
>--Posted from EarthWeb Discussions. http://discussions.earthweb.com
>
Received on Mon May 10 1999 - 13:46:08 CDT