问可以在Oracle或sybase中运行，但不能在netezza中运行。获取错误错误：(2)不支持这种形式的相关查询-请考虑重写

EN

create temp table table1 (
row_num int
,rel_no int
,hh_num int

);

insert into table1
select 1,        0,        null
union all
select 2,        6,        null
union all
select 3,        8,        null
union all
select 4,        0,        null
union all
select 5,        0,        null
union all
select 6,        0,        null
union all
select 7,        2,        null
union all
select 8,        3,        null
union all
select 9,        6,        null
union all
select 10,       0,       null;   

 update table1 a set hh_num = sub.hh_num
 from
 (select h.rowid as rown, h.row_num, h.rel_no, max(p.row_num) as hh_num
 from table1 h inner join
 table1 p
 on p.rel_no = 0 and p.row_num <h.row_num
 group by h.rowid, h.row_num, h.rel_no) sub
 where a.rowid=sub.rown;

  update table1 set hh_num = row_num
 where rel_no = 0;