3,490
社区成员
发帖
与我相关
我的任务
分享求一个Oracle 分页查询语句写法
我想查找 1到40记录 分页该怎么写 谢谢
SELECT DISTINCT A.YH_NAME,A.YH_ID_CARD,B.YH_LX,B.YH_WBJ,C.SF_YSJE,C.SF_SSJE FROM GNSF_YHZRXX A,GNSF_YHYEARXX B,GNSF_YHYEARSF C
SELECT DISTINCT A.YH_NAME,A.YH_ID_CARD,B.YH_LX,B.YH_WBJ,C.SF_YSJE,C.SF_SSJE FROM GNSF_YHZRXX A,GNSF_YHYEARXX B,GNSF_YHYEARSF C
...全文
请发表友善的回复…
发表回复
sy_22841597 2009-05-31
- 打赏
- 举报
谢谢拉
sy_22841597 2009-05-31
- 打赏
- 举报
要是 20 到 40这写也行呗
hebo2005 2009-05-31
- 打赏
- 举报
如果需要后面几页
select *
from(
SELECT rownum rn,DISTINCT A.YH_NAME,A.YH_ID_CARD,B.YH_LX,B.YH_WBJ,C.SF_YSJE,C.SF_SSJE FROM GNSF_YHZRXX A,GNSF_YHYEARXX B,GNSF_YHYEARSF C
where rownum<=page*pagenum)
where rn>(page-1)*pagenum
select *
from(
SELECT rownum rn,DISTINCT A.YH_NAME,A.YH_ID_CARD,B.YH_LX,B.YH_WBJ,C.SF_YSJE,C.SF_SSJE FROM GNSF_YHZRXX A,GNSF_YHYEARXX B,GNSF_YHYEARSF C
where rownum<=page*pagenum)
where rn>(page-1)*pagenum
hebo2005 2009-05-31
- 打赏
- 举报
没有特定排序要求
SELECT DISTINCT A.YH_NAME,A.YH_ID_CARD,B.YH_LX,B.YH_WBJ,C.SF_YSJE,C.SF_SSJE FROM GNSF_YHZRXX A,GNSF_YHYEARXX B,GNSF_YHYEARSF C
where rownum<=40
SELECT DISTINCT A.YH_NAME,A.YH_ID_CARD,B.YH_LX,B.YH_WBJ,C.SF_YSJE,C.SF_SSJE FROM GNSF_YHZRXX A,GNSF_YHYEARXX B,GNSF_YHYEARSF C
where rownum<=40
