Fill missing value

Question

Hi, i have a requirement as follows.

 

 

Value	ayValue
A	1
	23
	21
	22
B	34
	31
	89
C	222
	10

 

Output:

Value	ayValue
A	1
A	23
A	21
A	22
B	34
B	31
B	89
C	222
C	10

 

 I need this in ms sql and mysql, please help me.