SELECT G.*

  FROM (SELECT F.*

          FROM (SELECT E.*, ROWNUM ROWNO

                  FROM (SELECT T.ID,

                               T.VIRTUAL_ID,

                               T.INDEX_ID,

                               T.ID_CARD,

                               T.NAME,

                               T.CARDNUM,

                               T.CARDTYPE,

                               T.TELPHONE,

                               T.SEX,

                               TO_CHAR(T.BIRTHDAY, 'YYYY-MM-DD') BIRTHDAY,

                               T.ADDRESS,

                               T.ACCESS_TYPE,

                               T.ACCESS_ID,

                               T.ENTITY_CARDTYPE,

                               T.ENTITY_CARDNUM,

                               T.RETURN_QR_CODE,

                               T.OPENID,

                               T.RANDOM,

                               TO_CHAR(T.TIME, 'yyyy-mm-dd hh24:mi:ss') TIME,

                               T.FNAME,

                               T.STATUS,

                               T.QR_CODE_TYPE

                          FROM VIRTUAL_CARD T, PRIMARY_INDEX T2

                         WHERE T.INDEX_ID = T2.INDEX_ID

                           and NAME = ?

                           and INDEX_ID like ? || '%') E

                 ORDER BY E.TIME DESC NULLS LAST) F

         WHERE F.ROWNO <= ?) G

 WHERE G.ROWNO >= ?

--[张旭, 410, 15, 1]