FIND YOUR NEXT FEW LINES
Results for “os”
Small, practical examples. Search by task or narrow things down below.
809 snippets foundClear filters
Expand an array into rows
Use WITH ORDINALITY to retain original element order.
unnest✓ Tested
Explain which ignore rule matches a file
Git: check-ignore -v reports the source file, line, pattern, and matched path.
Git✓ Tested
Extract part of a date
Read a calendar component with EXTRACT.
EXTRACT✓ Tested
Extract part of a string
Use one-based positions with substr.
substr✓ Tested
Extract the low and high byte of a value
Arduino / C: lowByte and highByte expose the two bytes of a 16-bit value.
Arduino / C✓ Tested
Fetch a remote branch
Refresh remote-tracking references before reviewing changes.
fetch✓ Tested
Filter aggregate groups
Keep only categories with multiple products.
HAVING✓ Tested
Filter an array in place with a write index
C: Only retained values advance the write position.
C✓ Tested
Filter by a numeric comparison
SQL: Keep rows whose quantity exceeds a chosen threshold.
SQL✓ Tested
Filter by a numeric comparison
SQL Server: Keep rows whose quantity exceeds a chosen threshold.
SQL Server✓ Tested
Filter by a numeric comparison
SQLite: Keep rows whose quantity exceeds a chosen threshold.
SQLite✓ Tested
Filter groups after aggregation
SQL: Use HAVING to test a group’s calculated total.
SQL✓ Tested