Oracle 单表查询,带count
查询总条数,并给每一列赋值一个序号,用于分页(有总条数,有下标)
SELECT
count( * ) over ( ) count,
ROW_NUMBER ( ) over ( ORDER BY ID ASC ) row_num,
sys_infmain.*
FROM
sys_infmain
结果如下图:
查询总条数,并给每一列赋值一个序号,用于分页(有总条数,有下标)
SELECT
count( * ) over ( ) count,
ROW_NUMBER ( ) over ( ORDER BY ID ASC ) row_num,
sys_infmain.*
FROM
sys_infmain
结果如下图: