wenxi2367的博客

分别测试待合并的数据详细SQL:SELECT sum(s.Count) as ssumCount,s.CustormerId as scId from recordsuccessbycustomer as s group by s.CustormerId SELECT sum(f.Count) as fsumCount,f.CustormerId as fcId from recordfaile...

原始数据转化后的数据源代码：SELECT recordbytunnel.ttype, recordbytunnel.tsequense, tunnelId, MAX(CASE DataType WHEN 1 THEN RowCount ELSE 0 END) AS '发送总数Cmpp', MAX(CASE DataType WHEN 2 THEN RowCount ELSE 0 END) AS '...