Discuss when to use the GROUP BY clause
What will be an ideal response?
The GROUP BY clause is useful when you have a set of values for one column (such as a salesperson ID) and you would like to then calculate something like total sales for each salesperson. Rather than having to use the sum function with one salesperson's ID in the WHERE clause (and run multiple queries) you can use the GROUP BY to get the same results in one query.
Business
You might also like to view...
Verbs are the key _________ words in most sentences
a. inquiry b. subject c. action d. identifier
Business
If a firm wants to become more adaptive and flexible, which of the following organizational structures is it likely to prefer?
A) formalized B) mechanistic C) organic D) centralized
Business