如果是这样的
结果嵌套一层
SELECT B.MOBILE
FROM (SELECT A.MOBILE, ROWNUM RN
FROM (select MOBILE
from MOBILE_RECIPIENT
where MOBILE_DETAIL_ID = ?) A
WHERE ROWNUM <= ?)
WHERE RN > ?
如果是将后面的那两个$改成#号的话则执行的sql是
显然$效率更高。