Loading

SQL Query vs Asp.net gridview

Jerald Jayaraj D

i am having below MS Access Table now i need to sum the price for every customer

have to display into gridview

below format

kindly help me out Thanks in advance

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta7y ago
Accepted answer
Select customer, sum(price) from tableName group by customer
+2
Jerald Jayaraj D7y ago
thank you
0
Jenith Thakkar7y ago
Select Customer, Sum(Price) from TableName group by Customer
0