mysql
SELECT
a.*, @rowno1 :=@rowno1 + 1 pageindex
FROM
(
SELECT
t.id pkid,
@rowno :=@rowno + 1 bh
FROM
gsj_nsrhsqkmxb t,
(SELECT @rowno := 0) m
ORDER BY
t.id
) a,
(SELECT @rowno1 := 0) n
WHERE
MOD (bh, 100) = 0
oracle
SELECT
a.*, rownum pageindex
FROM
(
SELECT
t.id pkid,
rownum bh
FROM
HA_SZJJ_REC_XZCF t
ORDER BY
t.id
) a
WHERE
MOD (bh, 100) = 0