81,094
社区成员
发帖
与我相关
我的任务
分享
select *
from (select rownum r,
A.DWBM,
A.DWNM,
A.DWMC,
B.XMBM,
B.XMMC,
B.SFXX,
B.SFSX
from a, b, c
where a.DWNM = c.DWNM
and c.XMNM = b.XMNM
and regexp_like('aa', a.DWNM)
and regexp_like('aa', a.DWWM))
where rn > 0
and rn < 10
SELECT *
FROM (SELECT ROWNUM RN, A.D_WCODE, A.D_NAME, B.P_WCODE, B.P_NAME
FROM DEPART A, PROJECT B, PROINFO C
WHERE A.D_NCODE = C.D_NCODE
AND C.P_NCODE = B.P_NCODE
AND A.D_NAME LIKE '%3%'
AND A.D_WCODE LIKE '%1%')
WHERE RN >= 1 --分页变量
AND RN <= 10 --分页变量
SELECT *
FROM (SELECT A.D_WCODE, A.D_NAME, B.P_WCODE, B.P_NAME
FROM DEPART A, PROJECT B, PROINFO C
WHERE A.D_NCODE = C.D_NCODE
AND C.P_NCODE = B.P_NCODE
AND A.D_NAME LIKE '%3%'
AND A.D_WCODE LIKE '%1%')
WHERE ROWNUM >= 1 --分页变量
AND ROWNUM <= 10 --分页变量