SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT id AS "id", name AS "name", age AS "age", birth_date AS "birth_date", interest AS "interest", editor AS "editor", editor_dept AS "editor_dept", edit_at AS "edit_at", tenant_id AS "tenant_id", create_user AS "create_user", create_time AS "create_time", create_dept AS "create_dept", update_user AS "update_user", update_time AS "update_time", is_deleted AS "is_deleted", editor_id AS "editor_id", edit_dept_id AS "edit_dept_id" FROM lowcode_zexample_single_table tbl WHERE (is_deleted = 0) AND tbl.tenant_id = 1 ORDER BY id DESC ) TMP WHERE ROWNUM <=10) WHERE ROW_ID > 0
把控制台的语句,拷贝到到sql客户端执行,能正常执行
SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT id AS "id", name AS "name", age AS "age", birth_date AS "birth_date", interest AS "interest", editor AS "editor", editor_dept AS "editor_dept", edit_at AS "edit_at", tenant_id AS "tenant_id", create_user AS "create_user", create_time AS "create_time", create_dept AS "create_dept", update_user AS "update_user", update_time AS "update_time", is_deleted AS "is_deleted", editor_id AS "editor_id", edit_dept_id AS "edit_dept_id" FROM lowcode_zexample_single_table tbl WHERE (is_deleted = 0) AND tbl.tenant_id = 1 ORDER BY id DESC ) TMP WHERE ROWNUM <=10) WHERE ROW_ID > 0