如何加上行号用的是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