java完整分页算法_新人发一贴，java分页算法

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

SELECT tab.* FROM (SELECT tab.*,ROW_NUMBER() OVER(order by company_cd ,csmcd ,shopcd ) as no FROM ( SELECT c.rowid as id ,c.COMPANY_CD ,c.CSMCD ,c.SHOPCD ,c.DELETE_*** ,c.INPUTDATE ,c.STARTDATE ,c.ENDDATE ,c.CSMNAME ,c.CSMNAMEO ,c.CSMNAMEL ,c.CSMNAMEOL ,c.SHOPNAME ,c.SHOPNAMEO ,c.SHOPNAMEL ,c.SHOPNAMEOL ,c.TYPE1 ,b.CLASSBNAME type1nm ,c.TYPE2 ,c.TYPE3 ,c.CSMdistinguish ,c.CSMDistrict ,c.CSMZIP ,c.CSMADDR ,c.SHOPdistinguish ,c.SHOPDistrict ,a.AREANAME SHOPdistinguishnm ,d.DISTRICTNAME SHOPDistrictnm ,c.SHOPZIP ,c.SHOPADDR ,c.DELIVERYDATE ,c.BSTYPE ,c.Route ,r.route_nm routenm ,c.Distance ,c.WAITDATE ,c.IMP ,c.Consignment ,c.Shelflife ,g.CODE_NMCH shelflifenm ,c.FINANCESENDUSER ,c.FINANCESENDTEL ,c.FINANCESENDMOBILE ,c.FINANCESENDfax ,c.FINANCESENDADDR ,c.SENDUSER ,c.SENDTEL ,c.SENDMOBILE ,c.SENDfax ,c.SENDADDR ,c.CSMBusinessUSER ,c.CSMBusinessTEL ,c.CSMBusinessMOBILE ,c.CSMBusinesspost ,c.BusinessUSER ,c.BusinessTEL ,c.BusinessMOBILE ,c.Businesspost ,c.Financeuser ,c.Financetel ,c.FinanceMOBILE ,c.Financepost ,c.DELIVERYINFO ,c.EMPLOYEENO ,c.EMPLOYEENOad ,c.EMPLOYEENOin ,c.EMPLOYEENOout ,c.CSMORSHOP ,c.taxtype ,c.moneytype ,c.Invoicetype ,c.paytype ,c.Checkouttype ,c.Closingdate ,c.Accountingperiod ,c.BANKNO ,c.BANKNAME ,c.taxno ,c.OTHERCD ,c.rowid ,c.UPD ,c.UPDEMPLOYEENO ,c.CRED ,c.CREEMPLOYEENO FROM csm_mst c LEFT JOIN AREA_MST a on c.COMPANY_CD = a.COMPANY_CD and c.SHOPdistinguish = a.AREA LEFT JOIN CLASSB_MST b on c.COMPANY_CD = b.COMPANY_CD and c.TYPE1 = b.CLASSB LEFT JOIN route_mst r on c.COMPANY_CD = r.COMPANY_CD and c.Route = r.route_no LEFT JOIN DISTRICT_MST d on c.COMPANY_CD = d.COMPANY_CD and c.SHOPdistinguish = d.AREA and c.SHOPDistrict = d.DISTRICT LEFT JOIN GENERALDETAIL_MST g on c.COMPANY_CD = g.COMPANY_CD and g.CODENO ='S0005' and c.Shelflife =g.code WHERE c.Delete_*** <> '1' AND c.COMPANY_CD = '0001' ) tab ) tab WHERE tab.no > '0' and tab.no <= '20'

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！