使用db2获取某一行或者从N到M行结果

获取第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