sqlserver 分页查询

[gjj202008]

SELECT MZ_BRDA.MZHM,cwb_yjxx.BH, MZ_BRDA.BRXM, MZ_BRDA.BRXB, MZ_BRDA.CSRQ,cwb_yjxx.yc,cwb_yjxx.cc, cwb_yjxx.MCYJRQ, cwb_yjxx.YCRQ, cwb_yjxx.yyrq, MZ_BRDA.JTDH, cwb_yjxx.XJCS, cwb_yjxx.GWBH, cwb_yjxx.GWYS, cwb_yjxx.BZ,cwb_yjxx.JKRQ,MZ_BRDA.BRID,cwb_yjxx.CJTS,cwb_yjxx.CJYZ FROM cwb_yjxx INNER JOIN MZ_BRDA ON cwb_yjxx.BRID = MZ_BRDA.BRID WHERE  FMRQ IS NULL ORDER BY MCYJRQ desc 

我想写成分页查询的，怎么写呢？

[zhouzhijian888]

用 top ！~~~~~~~~~~~

[發糞塗牆]

引用 楼主 gjj202008 的回复:

XML/HTML code ? 1 SELECT MZ_BRDA.MZHM,cwb_yjxx.BH, MZ_BRDA.BRXM, MZ_BRDA.BRXB, MZ_BRDA.CSRQ,cwb_yjxx.yc,cwb_yjxx.cc, cwb_yjxx.MCYJRQ, cwb_yjxx.YCRQ, cwb_yjxx.yyrq, MZ_BRDA.JTDH, cwb_yjxx.XJ……

网上一大堆分页存储过程....