select *
from (select ROW_NUMBER() OVER() AS myRownum, t.*
from (select u.id, u.name p_name
from tuser u
where 1 = 1
and p_name is not null) t) aaa
where myRownum >= 1
and myRownum <= 10
删除字段重新加载表
reorg table XXXXX;
db2 ? xxx