随笔分类 -  数据库 / oracle

Oracle分页查询
摘要：SELECT * FROM ( SELECT A.*, ROWNUM RN FROM (SELECT * FROM bhis_gz_zg_360007002204.v_query_lis_pcas) A ) WHERE RN BETWEEN 1 AND 10 11 20 21 30 oracle没有 阅读全文
posted @ 2021-10-15 15:40 漫步花海下的oldman 阅读(64) 评论(0) 推荐(0)