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

Results for “portable paths”

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

320 snippets foundClear filters
SQLJoins & subqueries

Compare with a calculated value

Find products above the average price.

subquery✓ Tested
SQLReporting & grouped calculations

Compute an integer weighted average

SQL: Multiply before summing and guard a zero total weight with NULLIF.

SQL✓ Tested
SQLBulk changes & set operations

Copy selected rows into another table

SQL: INSERT SELECT performs a set-based copy with an explicit destination column list.

SQL✓ Tested
SQLReporting & grouped calculations

Count distinct values within a result

SQL: COUNT DISTINCT counts distinct non-null values.

SQL✓ Tested
SQLExpressions & aggregates

Count rows per category

Aggregate rows sharing the same category.

GROUP BY✓ Tested
SQLReporting & grouped calculations

Count rows satisfying separate conditions

SQL: SUM over CASE expressions calculates several conditional counts in one scan.

SQL✓ Tested
SQLGetting Started

Count the rows in a table

SQL: COUNT(*) includes every row, including rows with NULL columns.

SQL✓ Tested
SQLGetting Started

Create a table and insert its first row

SQL: Define column types and a primary key, then insert one row using an explicit column list.

SQL✓ Tested
SQLSchema design & transactions

Create an index for an equality filter

SQL: A nonunique index can support lookups on a frequently filtered column.

SQL✓ Tested
SQLSchema design & transactions

Create an index matching filter and ordering columns

SQL: Place the equality-filter column before the ordering column in this composite index.

SQL✓ Tested
C#Files & paths

Create nested directories

Create a directory tree using the .NET Directory API.

C#✓ Tested
JavaFiles & paths

Create nested directories

Create missing parent directories with Java Files.createDirectories.

Java✓ Tested