I use mybatis paging plug-in Oracle using the left join query sort out data disorder to do


SQL statements are as follows: select * from (select a. *, rownum as row_ from (select tc atalog_item_id, tc atalog_id, t.n ame, t.t itle of t.f ield_type, t.l ength, tc onstraints, t.d escription, t.t ag_id as tagId, which ag_name_cn as tagName, t.t ag_type as tagType, t.t ag_type_name as tagTypeName from data_catalog_item_standard t left JOIN data_tag_define d on t.t ag_id=which ag_id where 1=1 and tc atalog_id='a8466156ea484f0f85af7b408e468e98') where a rownum<=16) where row_ & gt;=1

CodePudding user response:

Paging query, there must be sorted to ensure that the data is stable,