Select * from (SELECT A. *, ROWNUM RN FROM (SELECT * home_name) a where #xxx) Where rn between #from and #to
Explanation: Table_name Name
#xxx: Conditions
#from record start
# t t 结