??? select city, no_orders, upto_two_orders, more_than_two_orders ??? form (select c.customerid,city,??? case ??? when COUNT(orderid)=0 then 'no_orders'??? when COUNT(orderid)<=2 then 'upto_two_orders'??? when COUNT(orderid)>2 then 'more_than_two_orders'??? end as category??? from dbo.Customers as c??? left outer join dbo.Orders as o??? on c.customerid=o.customerid??? group by c.customerid,city) as d??? PIOVT(COUNT(customerid) for??? category in ([no_orders],[upto_two_orders],[more_than_two_orders])) as p;
請高手幫我看看那里錯了，謝謝
sqlserver2005的問題
牛魔王的故事
2018-12-06 18:30:45
