Results for “SELECT”
Small, practical examples. Search by task or narrow things down below.
Keep rows matching a condition
SQLite: Use WHERE to select rows with a particular category.
SQLite✓ Tested
Label a volume with its purpose
Docker / Compose: Volume labels support explicit ownership and selection.
Docker / Compose✓ Tested
Label rows with CASE
Derive a readable label from a condition.
CASE✓ Tested
Limit a value to a safe interval
Clamp an integer between chosen endpoints.
constrain✓ Tested
List distinct values
Remove duplicate category values from a result.
DISTINCT✓ Tested
List only containers belonging to a label
Docker / Compose: A label filter selects explicitly tagged resources.
Docker / Compose✓ Tested
Maintain a rolling sum in a circular window
Arduino / C: Subtract the overwritten sample before adding the next one.
Arduino / C✓ Tested
Map an input range to an output range
Scale an integer reading to a different interval.
map✓ Tested
Match one of several values
Use IN to avoid repeating equality conditions.
IN✓ Tested
Measure a short delay with micros
Measure elapsed microseconds around a short operation.
micros✓ Tested
Name a fixed configuration value
Arduino / C: Name a fixed configuration value on an Uno with the Serial Monitor set to 9600 baud.
Arduino / C✓ Tested
Observe completion of queued work
jQuery: The queue promise resolves when the selected elements’ queue is empty.
jQuery✓ Tested