I have a table with the following example data:
Id | field1
1 | abc
2 |
3 | def
4 |
5 | dtg
6 |
7 | abc
Is there a way using sql only to fill in the nulls, as in the example below, with the value of the row above it?
Id | field1
1 | abc
2 | abc
3 | def
4 | def
5 | dtg
6 | dtg
7 | abc
Thanks in anticipation . . .
--
Steven
Id | field1
1 | abc
2 |
3 | def
4 |
5 | dtg
6 |
7 | abc
Is there a way using sql only to fill in the nulls, as in the example below, with the value of the row above it?
Id | field1
1 | abc
2 | abc
3 | def
4 | def
5 | dtg
6 | dtg
7 | abc
Thanks in anticipation . . .
--
Steven