Results for “comparison”
Small, practical examples. Search by task or narrow things down below.
Compare a value with a limit
PowerShell: Compare a value with a limit using PowerShell 7.
PowerShell✓ Tested
Compare a value with a limit
C++: Turn a comparison into a readable yes or no result.
C++✓ Tested
Compare a value with a limit
C: Turn a comparison into a readable yes or no result.
C✓ Tested
Compare with a calculated value
Find products above the average price.
subquery✓ Tested
Filter rows with WHERE
Keep products below a chosen price.
WHERE✓ Tested
Include missing values in a not-equal filter
SQL: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.
SQL✓ Tested
Include missing values in a not-equal filter
SQL Server: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.
SQL Server✓ Tested
Include missing values in a not-equal filter
Postgres: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.
Postgres✓ Tested
Include missing values in a not-equal filter
SQLite: Ordinary inequality does not include NULL; explicitly include it when that is the intended rule.
SQLite✓ Tested
Check a suffix without case sensitivity
PowerShell: Use an ordinal case-insensitive comparison for a known filename extension.
PowerShell✓ Tested
Check an extension without case sensitivity
C#: Use an explicit ordinal case-insensitive comparison for a known filename suffix.
C#✓ Tested
Check array membership with includes
JavaScript: includes uses SameValueZero comparison, which also matches NaN.
JavaScript✓ Tested