分页查询SQL

分类: IT文章 • 2023-12-01 15:56:01

SELECT
*
FROM
( SELECT
   T.*,
   ROWNUMBER() OVER() AS ROWNUM
  FROM
   ( SELECT
     L4_GDS_GROUP_CD CODE,
     L4_GDS_GROUP_DESC NAME
    FROM
     DM_GDS_GROUP_INF_TD
    WHERE
     (L4_GDS_GROUP_CD LIKE '%手工制作%' OR
     L4_GDS_GROUP_DESC LIKE '%手工制作%') FETCH FIRST 50 ROWS ONLY
   )
   T
)
WHERE
ROWNUM > 0 AND
ROWNUM <= 50