如何加上行号
用的是db2 v9.1 ，想给记录加上行号？这样写了，但不行：
select row_number() over() as num,* from tbP

[解决办法]
select row_number() over() as num,tbP.* from tbP
[解决办法]
select row_number() over(order by t.[FIELD1]) as num, t.* from tbP t