Does not recognize the reserved word Compute

Navigation
2

When trying to create this query in SQL Managament 

SELECT OrderID, ProductID, UnitPrice, Quantity, (UnitPrice * Quantity) FROM [Order Details]
WHERE OrderID < 10260
ORDER BY OrderID
COMPUTE SUM(Quantity) BY OrderId

I do not recognize COMPUTE I'm using SQL Server 2014 now another command is used, how can I fix it?

    
asked by Pedro Ávila 06.10.2016 в 16:47
source

1 answer

3

The COMPUTE clause is not supported from SQL Server 2012 . The documentation recommends using ROLLUP in return.

    
answered by 06.10.2016 / 16:49
source
Illegal character in output How to show all data consulted?