首頁猿問 sqlserver2005的問題

sqlserver2005的問題

SQL Server

牛魔王的故事 2018-12-06 18:30:45

??? 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; 請高手幫我看看那里錯了，謝謝

查看完整描述

5 回答

眼眸繁星

TA貢獻(xiàn)1873條經(jīng)驗(yàn) 獲得超9個贊

報什么錯？

反對回復(fù) 2019-01-07

胡說叔叔

TA貢獻(xiàn)1804條經(jīng)驗(yàn) 獲得超8個贊

關(guān)鍵字 'as' 附近有語法錯誤。

可奇怪我了，我跟書上寫的都不對

反對回復(fù) 2019-01-07

郎朗坤

TA貢獻(xiàn)1921條經(jīng)驗(yàn) 獲得超9個贊

個人認(rèn)為

??? 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) <--在這之前應(yīng)該沒錯這后面這個as是給誰附別名為D呢所以這該有錯->as d
???<--這個地方PIOVT不知道是什么沒見過--> PIOVT(COUNT(customerid) for
??? category in ([no_orders],[upto_two_orders],[more_than_two_orders])) as p;