获取第2行结果
select *from (select wuid,ROW_NUMBER() OVER(order by workseq asc) as a from WORKPROCESS where muid='702711' ) where a=2 ;
获取第10行到第20行结果
select *from (select wuid,ROW_NUMBER() OVER(order by workseq asc) as a from WORKPROCESS where muid='702711' ) where a>=10 and a<=20 ;
使用db2 -x 命令获取db2结果
wuid=`db2 -x "select wuid from (select wuid,ROW_NUMBER() OVER(order by workseq asc) as a from WORKPROCESS where muid='702711' ) where a=1"`
echo $wuid