FIND YOUR NEXT FEW LINES

Results for “empty”

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

487 snippets foundClear filters
SQL ServerWindow analytics

Divide an ordered result into numbered buckets

SQL Server: NTILE distributes rows across buckets; include a unique tie-breaker for deterministic assignment.

SQL Server✓ Tested
PostgresWindow analytics

Divide an ordered result into numbered buckets

Postgres: NTILE distributes rows across buckets; include a unique tie-breaker for deterministic assignment.

Postgres✓ 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
SQL ServerSchema design & transactions

Enforce a relationship between two columns

SQL Server: A row-level CHECK can require a start value to be no greater than an end value.

SQL Server✓ Tested
PostgresSchema design & transactions

Enforce a relationship between two columns

Postgres: A row-level CHECK can require a start value to be no greater than an end value.

Postgres✓ Tested
SQL ServerSchema design & transactions

Enforce uniqueness with a dedicated index

SQL Server: A unique index rejects a duplicate combination independently of query plans.

SQL Server✓ Tested
PostgresSchema design & transactions

Enforce uniqueness with a dedicated index

Postgres: A unique index rejects a duplicate combination independently of query plans.

Postgres✓ Tested
Linux CommandsGetting Started

Enter and leave a practice directory

Linux Commands: Enter and leave a practice directory using GNU/Linux commands in an empty practice directory.

Linux Commands✓ Tested
HTMLImages & embedded documents

Exclude a purely decorative image from accessible content

HTML: An empty alt indicates that this image adds no information beyond nearby content.

HTML✓ Tested
PostgresJSON & arrays

Expand an array into rows

Use WITH ORDINALITY to retain original element order.

unnest✓ Tested
Bash ScriptsProcesses & environment

Export a value to child processes

Bash Scripts: Only exported shell variables are inherited through the environment.

Bash Scripts✓ Tested