String.format("SELECT * FROM (SELECT ROWNUM RN,T.* FROM (%s) T WHERE ROWNUM<=%d) WHERE RN>=%d", sql, rowTo, rowFrom);