SELECT RO.* FROM (SELECT ROW_NUMBER() OVER (ORDER BY 1) AS ROW_NUM,RO1.* FROM (" + sqlAll + ")RO1 ) RO WHERE ROW_NUM>=:STARTLINENO AND ROW_NUM<=:ENDLINENO