Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Impossible SQL Task ??
Matt Randle wrote:
> We have a list of IDs / Codes / Identifiers as follows,
>
> ID Code Identifier
>
> 1 A Matthew
> 1 B Randle
> 2 A Larry
> 2 B Ellison
> 3 A Dave
> 4 B Some Surname
>
> We need to re-orient the table so it comes back as,
>
> ID A B
>
> 1 Matthew Randle
> 2 Larry Ellison
> 3 Dave
> 4 Some Surname
>
> Is this possible in SQL ?? I can obviously do it programatically but it
> would be more elegent to do it with on SQL statement ?? I seem to remember
> reading about some 'projection' facility availiable some SQL server that
> does this sort of thing.
>
> Cheers,
>
> Matt.
I'll take a wack at it.....select t1.id, t1.a, t2.b from t t1, t t2
where t1.id = t2.id and t1.code = 'A' and t2.code = 'B'
select 1 from t t1 where t1.id = t2.id and t1.code = 'A')
select 1 from t t2 where t2.id = t1.id and t2.code = 'B')
Do i pass the test ?
Regards,
Marc Mazerolle
InforMaze Technologies
Received on Fri Apr 30 1999 - 15:08:25 CDT