At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!
SELECT StoreId, SUM(TotalPayments) AS [Total Payments] FROM ac_Orders GROUP BY StoreId ORDER BY StoreId I have tried this SELECT OrderID, StoreId, SUM(TotalCharges) AS [Total Charges], SUM(TotalPayments) AS [Total Payments] FROM ac_Orders GROUP BY OrderID,StoreId ORDER BY OrderID, StoreId
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.