Queries (Visual Basic)

Aggregate Clause (Visual Basic)

Describes the Aggregate clause, which applies one or more aggregate functions to a collection.

Distinct Clause (Visual Basic)

Describes the Distinct clause, which restricts the values of the current range variable to eliminate duplicate values in query results.

From Clause (Visual Basic)

Describes the From clause, which specifies a collection and a range variable for a query.

Group By Clause (Visual Basic)

Describes the Group By clause, which groups the elements of a query result and can be used to apply aggregate functions to each group.

Group Join Clause (Visual Basic)

Describes the Group Join clause, which combines two collections into a single hierarchical collection.

Join Clause (Visual Basic)

Describes the Join clause, which combines two collections into a single collection.

Let Clause (Visual Basic)

Describes the Let clause, which computes a value and assigns it to a new variable in the query.

Order By Clause (Visual Basic)

Describes the Order By clause, which specifies the sort order for columns in a query.

Select Clause (Visual Basic)

Describes the Select clause, which declares a set of range variables for a query.

Skip Clause (Visual Basic)

Describes the Skip clause, which bypasses a specified number of elements in a collection and then returns the remaining elements.

Skip While Clause (Visual Basic)

Describes the Skip While clause, which bypasses elements in a collection as long as a specified condition is true and then returns the remaining elements.

Take Clause (Visual Basic)

Describes the Take clause, which returns a specified number of contiguous elements from the start of a collection.

Take While Clause (Visual Basic)

Describes the Take While clause, which includes elements in a collection as long as a specified condition is true and bypasses the remaining elements.

Where Clause (Visual Basic)

Describes the Where clause, which specifies a filtering condition for a query.

Concepts

Other Resources