sqlserver2005的问题

Question

    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; 请高手帮我看看那里错了，谢谢

Answer 1

报什么错？

Answer 2

关键字 'as' 附近有语法错误。

可奇怪我了，我跟书上写的都不对

Answer 3

个人认为

    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呢所以这该有错->as d
   <--这个地方PIOVT不知道是什么 没见过--> PIOVT(COUNT(customerid) for
    category in ([no_orders],[upto_two_orders],[more_than_two_orders])) as p;

Answer 4

也谢谢您