Results for “group_concat”

SQLiteQueries & text

Join values with a delimiter ↗

Concatenate rows in a specified order.

group_concat✓ Tested

SQL ServerDates & text

Join rows in a chosen order ↗

Aggregate text with STRING_AGG and WITHIN GROUP.

STRING_AGG✓ Tested

HTMLNative disclosure & dialogs

Allow one disclosure in a named group to stay open ↗

HTML: Matching details name attributes create an exclusive native accordion in supporting browsers.

HTML✓ Tested

SQL ServerSelect & page

Assign a rank within each group ↗

Number rows with a partitioned window.

ROW_NUMBER✓ Tested

AngularTemplate-driven forms

Bind a radio-button group ↗

Bind a radio-button group with a standalone Angular component and explicit browser behavior.

Angular✓ Tested

HTMLGetting Started

Build a first radio-button group ↗

HTML: Learn how to build a first radio-button group in a complete browser example.

HTML✓ 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

SQLReporting & grouped calculations

Calculate each group’s integer percentage of the total ↗

SQL: Multiply before division and protect against a zero denominator.

SQL✓ Tested

SQL ServerReporting & grouped calculations

Calculate each group’s integer percentage of the total ↗

SQL Server: Multiply before division and protect against a zero denominator.

SQL Server✓ Tested