SELECT *,ROW_NUMBER() OVER() AS row_num,  CEILING(ROW_NUMBER() OVER() / 10.0) AS page_num FROM table_name;
复制

假设每页包含 10 条数据