sql问题,我创建了一个视图,但问题来自于何时
我尝试使用 select * from the view 显示视图。
CREATE VIEW YearByYearSalesDelta as
WITH temp
as (select SalesPersonID,YEAR(DueDate) as SaleYear, SUM(SubTotal) as Total
from Sales.SalesOrderHeader
group by SalesPersonID, year(DueDate)
)
select NewYear.SalesPersonID,
OldYear.SaleYear AS OldYear,
NewYear.SaleYear as NewYear,
NewYear.Total-OldYear.Total as Delta
from temp AS OldYear
JOIN temp AS NewYear on NewYear.SalesPersonID=OldYear.SalesPersonID
AND NewYear.SaleYear-1=OldYear.SaleYear
SELECT * FROM dbo.YearByYearSalesDelta
消息显示
**Msg 156, Level 15, State 1, Procedure YearYearSalesDelta, Line 15
Incorrect syntax near the keyword 'SELECT'.**
您应该在视图之后使用批次分隔符 GO
CREATE VIEW YearByYearSalesDelta as
WITH temp
as (select SalesPersonID,YEAR(DueDate) as SaleYear, SUM(SubTotal) as Total
from Sales.SalesOrderHeader
group by SalesPersonID, year(DueDate)
)
select NewYear.SalesPersonID,
OldYear.SaleYear AS OldYear,
NewYear.SaleYear as NewYear,
NewYear.Total-OldYear.Total as Delta
from temp AS OldYear
JOIN temp AS NewYear on NewYear.SalesPersonID=OldYear.SalesPersonID
AND NewYear.SaleYear-1=OldYear.SaleYear
GO
SELECT * FROM dbo.YearByYearSalesDelta
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)