Oracle取出表的前N条记录?SELECT * FROM (SELECT a.*,ROWNUM rnum FROM t_user_account a WHERE a.faultco
Oracle取出表的前N条记录
?
SELECT * FROM (SELECT a.*,ROWNUM rnum FROM t_user_account a WHERE a.faultcount=4) WHERE rnum<=6 AND rnum >=3
?
?
?
?
?
Oracle取出表的前N条记录
?
SELECT * FROM (SELECT a.*,ROWNUM rnum FROM t_user_account a WHERE a.faultcount=4) WHERE rnum<=6 AND rnum >=3
?
?
?
?
?