sql-server - SQL 具有和圆形数据类型

Question

我对我制作的这个程序感到厌烦

Select FirstName|' '|LastName as Customer_Name ,sum(price) as SubTotal, 
sum(round(MaxPrice - MinPrice),2), (price + (MaxPrice - Minprice)) as Total 
from People join Customer_Owner 
on People.PeopleId = Customer_Owner.PeopleId  join Orders 
on People.PeopleId = Orders.CustomerId  join Order_Item 
on Orders.OrderId = Order_Item.OrderId  join Item 
on Order_Item.ItemId = Item.ItemId 
group by FirstName,LastName having city = 'Clinton' order by LastName;

输出应该是这样的，但是每当我运行我的代码时，它都会给我一个错误，它也会给我一个总和/舍入错误。

Customer Name                   Subtotal     Sales Tax  Total

---

Patricia Jones                  48.00        2.88       50.88     
Paul Jones                      19.70        1.18       20.88     
Tara Roswell                    4.49         0.27       4.76      
Simon Tara                      145.00       8.70       153.70    
Theodore Turner                 16.25        0.98       17.23   

标签： sql-server

Answer 1

它可以通过将数据类型转换为数字来解决如下

sum(round(cast(MaxPrice - MinPrice) as numeric(36,2)), (price + (MaxPrice - Minprice))) 作为总计

让我知道它是否不起作用