Results for “Schema design & transactions”

SQL ServerReporting & grouped calculations

Calculate each group’s numeric spread ↗

SQL Server: Subtract MIN from MAX to report the difference between extremes.

SQL Server✓ Tested

PostgresReporting & grouped calculations

Calculate each group’s numeric spread ↗

Postgres: Subtract MIN from MAX to report the difference between extremes.

Postgres✓ Tested

SQLiteReporting & grouped calculations

Calculate each group’s numeric spread ↗

SQLite: Subtract MIN from MAX to report the difference between extremes.

SQLite✓ Tested

SQL ServerTransactions & tables

Catch a T-SQL error ↗

Handle an expected conversion error in TRY/CATCH.

TRY CATCH✓ Tested

PostgresJSON & arrays

Check JSONB containment ↗

Test whether an object contains a key-value pair.

jsonb✓ Tested

PostgresJSON & arrays

Collect ordered values into an array ↗

Build a sorted array from query rows.

array_agg✓ Tested

SQLBulk changes & set operations

Combine results while retaining duplicates ↗

SQL: UNION ALL does not spend work removing equal rows.

SQL✓ Tested

SQL ServerBulk changes & set operations

Combine results while retaining duplicates ↗

SQL Server: UNION ALL does not spend work removing equal rows.

SQL Server✓ Tested

PostgresBulk changes & set operations

Combine results while retaining duplicates ↗

Postgres: UNION ALL does not spend work removing equal rows.

Postgres✓ Tested

SQLiteBulk changes & set operations

Combine results while retaining duplicates ↗

SQLite: UNION ALL does not spend work removing equal rows.

SQLite✓ Tested

SQLText cleanup & matching

Combine text values with a separator ↗

SQL: Use the concatenation operator supported by the selected SQL dialect.

SQL✓ Tested

SQL ServerText cleanup & matching

Combine text values with a separator ↗

SQL Server: Use the concatenation operator supported by the selected SQL dialect.

SQL Server✓ Tested