我使用mybatis分頁插件 Oracle 使用left join查詢出來資料排序錯亂 怎么辦
sql陳述句如下：select * from (select a.*,rownum as row_ from (SELECT t.catalog_item_id,t.catalog_id, t.name, t.title, t.field_type, t.length, t.constraints, t.description,t.tag_id as tagId, d.tag_name_cn as tagName, t.tag_type as tagType, t.tag_type_name as tagTypeName FROM data_catalog_item_standard t left JOIN data_tag_define d on t.tag_id = d.tag_id where 1=1 and t.catalog_id ='a8466156ea484f0f85af7b408e468e98') a where rownum<=16)where row_>=1
uj5u.com熱心網友回復：
分頁查詢，必須有排序，才能保證資料是穩定的。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/63532.html
標籤：開發