摘要: ---分组partition by;统计:Count();合并:for xml path('') with cte as( select COUNT(t2.Id) OVER(PARTITION BY t2.Id) as Count,t1.Contact,t1.OrderNo ,t2.Name,t2.Wechat,t2.Id from B_BusinessOrder t1 join Sys_Use... 阅读全文
posted @ 2017-03-27 16:01 自由的鱼 阅读(2512) 评论(0) 推荐(0) 编辑