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

Results for “Structured data & serialization”

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

644 snippets foundClear filters
SQLGetting Started

Remove duplicate result values

SQL: Use DISTINCT when repeated category values are not useful.

SQL✓ Tested
SQL ServerGetting Started

Remove duplicate result values

SQL Server: Use DISTINCT when repeated category values are not useful.

SQL Server✓ Tested
SQLBulk changes & set operations

Remove duplicate values while keeping the smallest key

SQL: Identify retained keys in a grouped subquery before deleting other copies.

SQL✓ Tested
SQL ServerBulk changes & set operations

Remove duplicate values while keeping the smallest key

SQL Server: Identify retained keys in a grouped subquery before deleting other copies.

SQL Server✓ Tested
PostgresBulk changes & set operations

Remove duplicate values while keeping the smallest key

Postgres: Identify retained keys in a grouped subquery before deleting other copies.

Postgres✓ Tested
SQLiteBulk changes & set operations

Remove duplicate values while keeping the smallest key

SQLite: Identify retained keys in a grouped subquery before deleting other copies.

SQLite✓ Tested
SQLText cleanup & matching

Remove surrounding spaces from text

SQL: TRIM removes leading and trailing space characters by default.

SQL✓ Tested
SQL ServerText cleanup & matching

Remove surrounding spaces from text

SQL Server: TRIM removes leading and trailing space characters by default.

SQL Server✓ Tested
PostgresText cleanup & matching

Remove surrounding spaces from text

Postgres: TRIM removes leading and trailing space characters by default.

Postgres✓ Tested
SQLiteText cleanup & matching

Remove surrounding spaces from text

SQLite: TRIM removes leading and trailing space characters by default.

SQLite✓ Tested
SQLWindow analytics

Repeat the first ordered value beside each row

SQL: FIRST_VALUE reads the first value in the current window frame.

SQL✓ Tested
SQL ServerWindow analytics

Repeat the first ordered value beside each row

SQL Server: FIRST_VALUE reads the first value in the current window frame.

SQL Server✓ Tested