over(order by 排序字段 asc ) as rowid from 表名 )as a where a.rowid
>= startPage AND a.rowid
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 留着上面的语句加深印象。