Sorting Options By Group By
Hossein.K
6,642
Use the group by clause to group selected records by field. The following
example shows how to display the number of sales orders by customer group
from the Sales table.
The output would be a list of customer groups with the total number of sales
orders that exist for customers in that group. The count() function counts the total
number of records and places the result in the field specified in the brackets.
Best Regards,
Hossein Karimi
example shows how to display the number of sales orders by customer group
from the Sales table.
1 | SalesTable salesTable; |
The output would be a list of customer groups with the total number of sales
orders that exist for customers in that group. The count() function counts the total
number of records and places the result in the field specified in the brackets.
Best Regards,
Hossein Karimi
*This post is locked for comments