Results for “WHERE”
Small, practical examples. Search by task or narrow things down below.
Filter rows with WHERE
Keep products below a chosen price.
WHERE✓ Tested
Delete one matching row
Remove a selected record and inspect what remains.
DELETE✓ Tested
Filter items in a pipeline
Keep numbers that meet a condition.
Where-Object✓ Tested
Keep rows matching a condition
SQL: Use WHERE to select rows with a particular category.
SQL✓ Tested
Keep rows matching a condition
SQL Server: Use WHERE to select rows with a particular category.
SQL Server✓ Tested
Keep rows matching a condition
Postgres: Use WHERE to select rows with a particular category.
Postgres✓ Tested
Keep rows matching a condition
SQLite: Use WHERE to select rows with a particular category.
SQLite✓ Tested
Update one matching row
Change a value with an explicit filter.
UPDATE✓ Tested
Filter aggregate groups
Keep only categories with multiple products.
HAVING✓ Tested
Filter even numbers
Use LINQ Where to keep even C# values.
C#✓ Tested
Filter rows before grouping
SQL: WHERE limits the rows contributing to the aggregate; it differs from filtering completed groups with HAVING.
SQL✓ Tested
Filter rows before grouping
SQL Server: WHERE limits the rows contributing to the aggregate; it differs from filtering completed groups with HAVING.
SQL Server✓ Tested