Question: What is the SQL command to list the total sales
What is the SQL command to list the total sales by customer, month and product, with subtotals by customer and by month and a grand total for all product sales?
Answer to relevant QuestionsWhat is the SQL command to list the total sales by region and customer, with subtotals by region and a grand total for all sales? Using the answer to Problem 10 as your base, what command would you need to generate the same output but with subtotals in all columns?What is OLE-DB used for, and how does it differ from ODBC?What is XML, and why is it important? What are scripts, and what is their function? (Think in terms of database applications development!)
Post your question