view current row with previous value
567881Jun 18 2010 — edited Jun 18 2010Hi all,
I have a bit prob on how to display value on column which is have null value. For example :
SQL> select * from myTable;
ID COLUMN1 COLUMN2
----- ----- -----
1 1001 1001
2 1002 1001
3 1003 1001
3 1004
if i found null value in column2 then i wanna display value from previous row for that column.
Expected result :
ID COLUMN1 COLUMN2
----- ----- -----
1 1001 1001
2 1002 1001
3 1003 1001
3 1004 1001
Can somebody help me???