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

Results for “categories”

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

6 snippets foundClear filters
SQLSelect & filter

List distinct values

Remove duplicate category values from a result.

DISTINCT✓ Tested
SQLGetting Started

Calculate a total for each group

SQL: Group nonmissing categories and calculate separate totals.

SQL✓ Tested
SQL ServerGetting Started

Calculate a total for each group

SQL Server: Group nonmissing categories and calculate separate totals.

SQL Server✓ Tested
PostgresGetting Started

Calculate a total for each group

Postgres: Group nonmissing categories and calculate separate totals.

Postgres✓ Tested
SQLiteGetting Started

Calculate a total for each group

SQLite: Group nonmissing categories and calculate separate totals.

SQLite✓ Tested
SQLExpressions & aggregates

Filter aggregate groups

Keep only categories with multiple products.

HAVING✓ Tested