SELECT * FROM (SELECT a.*,ROWNUM rnum FROM t_user_account a WHERE a.faultcount=4) WHERE rnum<=6 AND rnum >=3