best2my的博客

现象：列表排序字段为空时会使排序紊乱 SELECT * FROM ( SELECT tmp_page.*, ROWNUM row_id FROM ( SELECT * FROM TR_TASK_PUBLISH WHERE TASK_ID = '1000021' ORDER BY COMMIT_TIME DESC ) tmp_page WHERE ROWNUM <= 20 ) WHERE row_id > 10;

大萨达撒