Results for “Ordering & set operations”
Small, practical examples. Search by task or narrow things down below.
Filter aggregate groups
Keep only categories with multiple products.
HAVING✓ Tested
Filter history by its author identity
Git: The author filter selects commits by their recorded author metadata.
Git✓ Tested
Filter rows with WHERE
Keep products below a chosen price.
WHERE✓ Tested
Find a commit that changed the count of a text string
Git: The pickaxe -S option finds commits that add or remove occurrences of a literal string.
Git✓ Tested
Find a division remainder
Arduino / C: Find a division remainder on an Uno with the Serial Monitor set to 9600 baud.
Arduino / C✓ Tested
Find a named container in the created state
Docker / Compose: Combine name and status filters to narrow a listing.
Docker / Compose✓ Tested
Find branches that contain a selected commit
Git: branch --contains limits the list to branches whose histories include the chosen revision.
Git✓ Tested
Find commits by message
Search commit subjects and bodies for a phrase.
log✓ Tested
Find rows with a related record
Use EXISTS without duplicating the outer rows.
EXISTS✓ Tested
Find text inside tracked files
Git: Find text inside tracked files inside the disposable repository created by the input setup.
Git✓ Tested
Find the commit responsible for a line
Inspect line attribution in a stable machine-readable format.
blame✓ Tested
Find the final day of a month
Use EOMONTH without manually calculating month length.
EOMONTH✓ Tested