该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
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'