Oracle的翻页SQL

    技术2022-05-11  59

    例如从第11条到第20条 select * from (

           select row_.*, rownum rownum_ from (                   select person_id, chn_name, chn_firstname_py from student                   ) row_ where rownum <=20           ) where rownum_ >=11

     

    最新回复(0)