var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Simple group by query
I have a source data like this.
Customer_ID Product Price Customer_Name Customer_Address
001 1 30 John Smith
001 2 50 John Smith
Certainly, this table is not normalized, but that's how t he source data is like. But I want to do is to have total each customer sales with its details (name etc), for example:
Customer_ID Price Customer_Name Customer_Address
001 80 John Smith
Does anyone know how to do this ? Thanks.
Is it possible to have a customer table based on the source data ?
select Customer_ID, sum(Price)
, Customer_Name, Customer_Address
group by Customer_ID, Customer_Name, Customer_Address