//以下sql表示取5条数据 从1取到5

select * from (select dslsid,zzjgdm,frmc,frlx,mc,frzs,fddbrxm,clrq,frzch,nsrglm,
swdjrq,bgbs,bgcz,bgrq,swdjjgdm,orgdeptname,nsrsbh ,rownumber()
over(order by dslsid asc ) as rowid from FR_V_DSLS )as a
where a.rowid BETWEEN 1 AND 6

不好意思，犯了个低级错误，上面的sql语句是有误的，原因在于对
between and的错误理解

本人记得between and是包含前者，不包含后者，实验表明，
between and 前后两者都包含。

所以上述语句应修改为：

select * from (select dslsid,zzjgdm,frmc,frlx,mc,frzs,
fddbrxm,clrq,frzch,nsrglm,swdjrq,
bgbs,bgcz,bgrq,swdjjgdm,orgdeptname,nsrsbh ,rownumber()
over(order by dslsid asc ) as rowid from FR_V_DSLS )as
a where a.rowid >= 1 AND a.rowid < 6

留着上面的语句加深印象。