-
众羽
发布于 2021-01-01 15:16
-
收藏
看代码吧~WITH Name AS ( SELECT* FROM( SELECTxzqdm,SUBSTRING (zldwdm, 1, 9) xzdm,COUNT (*) sl FROMsddltb_qc WHERExzqdm IN ('130432', '210604') GROUP BYxzqdm,SUBSTRING (zldwdm, 1, 9)) AS A ORDER BYxzqdm,xzdm,sl) SELECT xzqdm, xzdm, ..