SQL Problem

[David]

Table A
Name Score
A 12
A 22
A 88
B 34
B 12
C 33
C 55


Table B

Name Score
A 12
NuLL 22
Null 88
B 34
Null 12
C 33
NUll 55

How can i create table b base on table a ?

[AK]

Re: SQL Problem

>

Is can this be runn on Oracle? I would be pleased to know more about
this type of syntax.
>

Yes, it runs on Oracle 9i. If you google 'OLAP functions', 'analytical
functions' you'll get a lot of useful links