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

Results for “duplicates”

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

27 snippets foundClear filters
SQLSubqueries & ranked selection

Report duplicate business values and their frequency

SQL: Group by a candidate business key and retain only groups with multiple rows.

SQL✓ Tested
SQL ServerSubqueries & ranked selection

Report duplicate business values and their frequency

SQL Server: Group by a candidate business key and retain only groups with multiple rows.

SQL Server✓ Tested
PostgresSubqueries & ranked selection

Report duplicate business values and their frequency

Postgres: Group by a candidate business key and retain only groups with multiple rows.

Postgres✓ Tested
SQLiteSubqueries & ranked selection

Report duplicate business values and their frequency

SQLite: Group by a candidate business key and retain only groups with multiple rows.

SQLite✓ Tested
SQLBulk changes & set operations

Find rows shared by two query results

SQL: INTERSECT compares complete selected rows and removes duplicates.

SQL✓ Tested
SQL ServerBulk changes & set operations

Find rows shared by two query results

SQL Server: INTERSECT compares complete selected rows and removes duplicates.

SQL Server✓ Tested
PostgresBulk changes & set operations

Find rows shared by two query results

Postgres: INTERSECT compares complete selected rows and removes duplicates.

Postgres✓ Tested
SQLiteBulk changes & set operations

Find rows shared by two query results

SQLite: INTERSECT compares complete selected rows and removes duplicates.

SQLite✓ Tested
C#Collections & data structures

Find values missing from another collection

C#: Except removes duplicates as it calculates the set difference.

C#✓ Tested
SQLRelationships & missing data

List unordered pairs without duplicate reversals

SQL: Join using an increasing key comparison to omit self-pairs and reversed duplicates.

SQL✓ Tested
SQL ServerRelationships & missing data

List unordered pairs without duplicate reversals

SQL Server: Join using an increasing key comparison to omit self-pairs and reversed duplicates.

SQL Server✓ Tested
PostgresRelationships & missing data

List unordered pairs without duplicate reversals

Postgres: Join using an increasing key comparison to omit self-pairs and reversed duplicates.

Postgres✓ Tested