sql语句 mysql数据库可以通过 想问下db2的该改成咋样的

[aiyinsitan215]

SELECT gorp,AVG(chazhi) avg1 FROM (SELECT * FROM
(SELECT CASE WHEN (j4.temp1-j3.temp1)>86400
THEN @temp_1:=@temp_1+1 ELSE @temp_1 END gorp,(j4.temp1-j3.temp1) chazhi FROM
(SELECT @rownum:=@rownum+1 rownum ,j1.scrq, MIDNIGHT_SECONDS(j1.scrq) temp1
FROM jgsj j1,(SELECT @rownum:=0,@temp_1:=1 from dual) j2 where j1.qyjc='43011' and j1.scrq>'2012-01-01' and j1.scrq<'2012-12-12' ORDER BY j1.scrq) j3 join
(SELECT @rownum1:=@rownum1+1 rownum ,j1.scrq, MIDNIGHT_SECONDS(j1.scrq) temp1
FROM jgsj j1,(SELECT @rownum1:=0 from dual) j2 where j1.qyjc='43011' and j1.scrq>'2012-01-01' and j1.scrq<'2012-12-12' ORDER BY j1.scrq) j4 on j3.rownum=j4.rownum-1) j5 where j5.chazhi<86400) t2
GROUP BY gorp

[WWWWA]

在DB2下可以用OW_NUMBER() OVER()

[aiyinsitan215]

除了这个号好像其他的也不行 @temp_1:=@temp_1+1 请问db2里面怎么赋值

[mysdzlt2007]

select val1 into val2... 或者 set val1=val2;