Описание тега where

Описание тега Вопросы с тегом
A clause in programming that applies a Boolean condition (predicate).

The where clause in programming applies a Boolean condition (predicate) in a statement. It is used in several programming languages, as well as SQL, in a variety of ways:

  1. C# LINQ: The where clause is used in a query expression to specify which elements from the data source will be returned in the query expression.

  2. C# Generics: http://msdn.microsoft.com/en-us/library/6b0scde8(v=vs.80).aspx

  3. SQL: A WHERE clause in SQL specifies that a SQL Data Manipulation Language (DML) statement should only affect rows that meet specified criteria. It is also a reserved word. For example, consider SELECT * FROM mytable WHERE mycol > 100.