12 2020 档案

sql server full join拼接表数据，按组加序号
摘要：--查询所有数据select A.*,B.* from(select z.id,z.requestId,z.FBillNo,dt5.FCauseAndProcess,dt5.FEquipmentNo,dt2.FDetail,row_number() over (PARTITION BY z.id O 阅读全文
posted @ 2020-12-04 18:32 Marie_yl 阅读(333) 评论(0) 推荐(0)