分页

SELECT ID, RN

  FROM (SELECT ROWNUM RN, ID
       
          FROM (SELECT RY.ID ID
                  FROM T_SQJZ_RYMC RY
                 WHERE 1 = 1
                 ORDER BY startTime desc nulls last, RY.Id desc)
         WHERE ROWNUM <= 20)
 WHERE RN >= 11;
 

 

   select *
     from (select *
             from (select t.id,
                          row_number() over(order by t.id desc) as indexNum
                     from T_SQJZ_RYMC t
                    where 1 = 1)
          
            where indexNum >= 11)
    where indexNum <= 20;

 

SELECT ID, rn
  FROM (SELECT ROWNUM RN, ID
       
          FROM (select ID
                  FROM (SELECT S.ID
                       
                          FROM T_SQJZ_SPONSOR S
                         WHERE 1 = 1
                       
                         order by S.TIME desc nulls last, S.Id desc)
                  )
         )
 WHERE RN BETWEEN 10 and 20

 

效率高：rid
select *
  from T_SQJZ_VOICE
 where rowid in (select rid
                   from (select rownum rn, rid
                           from (select rowid rid, id
                                   from T_SQJZ_VOICE
                                  order by id desc)
                          where rownum <= 10)
                  where rn >= 1
                
                 )
 order by id asc;