Crear cuenta
DECLARE @Table TABLE( ID INT,Val INT
)INSERT INTO @Table (ID,Val) SELECT 1, 3
INSERT INTO @Table (ID,Val) SELECT 2, NULL
INSERT INTO @Table (ID,Val) SELECT 3, 5
INSERT INTO @Table (ID,Val) SELECT 4, NULL
INSERT INTO @Table (ID,Val) SELECT 5, NULL
INSERT INTO @Table (ID,Val) SELECT 6, 2
SELECT *,
ISNULL(Val, (SELECT TOP 1 Val FROM @Table WHERE ID > t.ID AND Val IS NOT NULL ORDER BY ID ASC))
FROM @Table t
mysql> SELECT id, nombre, sueldo
-> FROM miTabla;
+------+---------+--------+
| id | nombre | sueldo |
+------+---------+--------+
| 1 | Juan | 37 |
| 2 | Perico | NULL |
| 3 | Andres | 5 |
| 4 | Roberto | 12 |
| 5 | Antonio | NULL |
| 6 | Leo | 10 |
| 7 | Josue | NULL |
+------+---------+--------+
7 rows in set (0.00 sec)
mysql> SELECT-> T1.id,
-> T1.nombre,
-> IFNULL(T1.sueldo, (SELECT sueldo
-> FROM miTabla T2
-> WHERE
-> T2.id > T1.id
-> AND T2.sueldo IS NOT NULL
-> ORDER BY id
-> LIMIT 1)
-> ) sueldo
-> FROM miTabla T1;
+------+---------+--------+
| id | nombre | sueldo |
+------+---------+--------+
| 1 | Juan | 37 |
| 2 | Perico | 5 |
| 3 | Andres | 5 |
| 4 | Roberto | 12 |
| 5 | Antonio | 10 |
| 6 | Leo | 10 |
| 7 | Josue | NULL |
+------+---------+--------+
7 rows in set (0.00 sec)