Oracle 单表查询，带count

分类: 文章 • 2022-10-27 18:34:44

查询总条数，并给每一列赋值一个序号，用于分页(有总条数，有下标)

SELECT
count( * ) over ( ) count,
ROW_NUMBER ( ) over ( ORDER BY ID ASC ) row_num,
sys_infmain.*
FROM
sys_infmain

结果如下图:
Oracle 单表查询，带count