<sql id="pageS">
select c.* from (
select b.* from
(select @rownum :=@rownum + 1 AS rm,a.* from
(SELECT @rownum := 0) r,
) a ) b where b.rm <= #{page}) c where c.rm >= #{page}
select c.* from (
select b.* from
(select @rownum :=@rownum + 1 AS rm,a.* from
(SELECT @rownum := 0) r,
(
</sql>
<sql id="pageE">) a ) b where b.rm <= #{page}) c where c.rm >= #{page}
</sql>
oracle:
SELECT *
FROM (SELECT M.*, ROWNUM RN
FROM (
select ques_name,ques_type,ques_options,ques_score,ques_s