< <
> >
举个栗子:
SELECT t2.id,t2.name FROM (SELECT t1.*,ROWNUM r FROM (SELECT * FROM t_role) t1
WHERE ROWNUM <=#{end}) t2 WHERE r > #{start}
< <
> >
举个栗子:
SELECT t2.id,t2.name FROM (SELECT t1.*,ROWNUM r FROM (SELECT * FROM t_role) t1
WHERE ROWNUM <=#{end}) t2 WHERE r > #{start}