</>SnippetSearch. A little code. A lot of possibility.
FIND YOUR NEXT FEW LINES

Results for “Encoding & structured values”

Small, practical examples. Search by task or narrow things down below.

391 snippets foundClear filters
SQLiteReporting & grouped calculations

Distinguish row count from non-null value count

SQLite: COUNT(*) includes every row while COUNT(column) skips NULL values.

SQLite✓ Tested
SQLConstraints & defaults

Enforce a bounded numeric range

SQL: A named CHECK constraint keeps numeric values inside an inclusive interval.

SQL✓ Tested
SQL ServerConstraints & defaults

Enforce a bounded numeric range

SQL Server: A named CHECK constraint keeps numeric values inside an inclusive interval.

SQL Server✓ Tested
PostgresConstraints & defaults

Enforce a bounded numeric range

Postgres: A named CHECK constraint keeps numeric values inside an inclusive interval.

Postgres✓ Tested
SQLiteConstraints & defaults

Enforce a bounded numeric range

SQLite: A named CHECK constraint keeps numeric values inside an inclusive interval.

SQLite✓ Tested
PythonCollections

Filter a list with a condition

Build a new list containing only the values that satisfy a condition using a list comprehension.

list✓ Tested
CArray transformations

Filter an array in place with a write index

C: Only retained values advance the write position.

C✓ Tested
C#Collections

Filter even numbers

Use LINQ Where to keep even C# values.

C#✓ Tested
JavaCollections

Filter even numbers

Use a Java stream to collect only even values.

Java✓ Tested
JavaScriptArrays

Filter even numbers

Create a JavaScript array containing only even values.

JavaScript✓ Tested
PowerShellHashtables & object records

Find differences between two collections

PowerShell: Compare-Object marks reference-only values with a left arrow and difference-only values with a right arrow.

PowerShell✓ Tested
jQueryAnimation completion

Finish all queued animations immediately

jQuery: finish jumps current and queued animations to their final values.

jQuery✓ Tested