[color=green]
SELECT * FROM (SELECT s.*,ROWNUM rn FROM(SELECT * FROM SZZP_TEST ) s WHERE ROWNUM<100) WHERE rn>50;
[/color]