编程论坛
注册
登录
编程论坛
→
SQL Server论坛
[求助]这个是什么意思
wsq1168
发布于 2007-10-18 08:03, 517 次点击
select VendorID,[164] as S164,[198] as S198
from
(select PurchaseOrderID,EmployeeID,VendorID
from Purchasing.PurchaseOrderHeader) p
pivot
(
count(PurchaseOrderID)
for EmployeeID in ([164],[198])
)
as pvt
order by VendorID
0 回复
1