Group By Clause (Visual Basic)
Groups the elements of a query result. Can also be used to apply aggregate functions to each group. The grouping operation is based on one or more keys.
You can use the Group By clause to break the results of a query into groups. The grouping is based on a key or a composite key consisting of multiple keys. Elements that are associated with matching key values are included in the same group.
You use the aggregateList parameter of the Into clause and the Group keyword to identify the member name that is used to reference the group. You can also include aggregate functions in the Into clause to compute values for the grouped elements. For a list of standard aggregate functions, see Aggregate Clause (Visual Basic).
The following code example groups a list of customers based on their location (country) and provides a count of the customers in each group. The results are ordered by country name. The grouped results are ordered by city name.
Public Sub GroupBySample() Dim customers = GetCustomerList() Dim customersByCountry = From cust In customers _ Order By cust.City _ Group By CountryName = cust.Country _ Into RegionalCustomers = Group, Count() _ Order By CountryName For Each country In customersByCountry Console.WriteLine(country.CountryName & _ " (" & country.Count & ")" & vbCrLf) For Each customer In country.RegionalCustomers Console.WriteLine(vbTab & customer.CompanyName & _ " (" & customer.City & ")") Next Next End Sub