Results for “empty”
Small, practical examples. Search by task or narrow things down below.
Select a range of array elements
Bash Scripts: Quote a sliced at-sign expansion to keep each selected element separate.
Bash Scripts✓ Tested
Select the highest values with TOP
Limit an ordered SQL Server result.
TOP✓ Tested
Select the top row in each group with a tie-breaker
SQL Server: Filter an outer query on ROW_NUMBER because window functions are not evaluated in WHERE.
SQL Server✓ Tested
Select the top row in each group with a tie-breaker
Postgres: Filter an outer query on ROW_NUMBER because window functions are not evaluated in WHERE.
Postgres✓ Tested
Select values in an inclusive range
SQL Server: BETWEEN includes both endpoints of the range.
SQL Server✓ Tested
Select values in an inclusive range
Postgres: BETWEEN includes both endpoints of the range.
Postgres✓ Tested
Send command output into another command
Linux Commands: Send command output into another command using GNU/Linux commands in an empty practice directory.
Linux Commands✓ Tested
Separate an executable from default arguments
Docker / Compose: Separate an executable from default arguments with a complete introductory Dockerfile.
Docker / Compose✓ Tested
Serialize query rows as JSON
Return a JSON array directly from a SELECT.
FOR JSON✓ Tested
Set a default non-root image user
Docker / Compose: Set a default non-root image user with a complete introductory Dockerfile.
Docker / Compose✓ Tested
Set a service’s working directory
Docker / Compose: Set a service’s working directory in a small Compose file.
Docker / Compose✓ Tested
Set a working directory
Choose the default directory for later instructions and the running process.
Dockerfile✓ Tested