问关于group by的问题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

问关于group by的问题

问关于group by的问题# Database - 数据库

D*r2005-03-05 08:03

1 楼

My table has following fields:
OrderID, Customer, Price, Quantity
Then how I can get the total price by Customer for all Customers?
Thanks in advance.

t*s2005-03-05 08:03

2 楼

select Customer, sum(Price) from YourTable
group by Customer

【在 D*******r 的大作中提到】

: My table has following fields:
: OrderID, Customer, Price, Quantity
: Then how I can get the total price by Customer for all Customers?
: Thanks in advance.

r*y2005-03-05 08:03

3 楼

You didn't count the quantity ah.
What I want is like sum(price*quantity) group by customer
but cannot use sum(price*quantity), it does not work since price*quantity is
not a column.
any advice?

【在 t*****s 的大作中提到】

: select Customer, sum(Price) from YourTable
: group by Customer

m*g2005-03-05 08:03

4 楼

create an extra view

【在 r****y 的大作中提到】

: You didn't count the quantity ah.
: What I want is like sum(price*quantity) group by customer
: but cannot use sum(price*quantity), it does not work since price*quantity is
: not a column.
: any advice?

m*g2005-03-05 08:03

5 楼

forget it, I just found you can use
SELECT Customer, SUM(Price * Quantity) AS Prices
FROM dbo.Table1
GROUP BY Customer

【在 m*****g 的大作中提到】

: create an extra view

t*s2005-03-05 08:03

6 楼

select Customer, Total = sum(Price*Quantity) from YourTable
group by Customer

【在 r****y 的大作中提到】