Results for “rows”
Small, practical examples. Search by task or narrow things down below.
Find rows shared by two query results
SQLite: INTERSECT compares complete selected rows and removes duplicates.
SQLite✓ Tested
Find rows with a related record
Use EXISTS without duplicating the outer rows.
EXISTS✓ Tested
Give a document a descriptive browser title
HTML: The title element supplies the browser document title independently of the visible heading.
HTML✓ Tested
Give implicit grid rows a minimum height
CSS: Minmax allows an implicit row to grow when its content requires more room.
CSS✓ Tested
Identify headers for individual table rows
HTML: Scope row associates the first header cell with the data cells in that row.
HTML✓ Tested
Inspect deleted rows
Return values from the rows a DELETE removes.
DELETE✓ Tested
Join related rows from two tables
SQL: Match a category key to its display label with an explicit join condition.
SQL✓ Tested
Join related rows from two tables
SQL Server: Match a category key to its display label with an explicit join condition.
SQL Server✓ Tested
Join related rows from two tables
Postgres: Match a category key to its display label with an explicit join condition.
Postgres✓ Tested
Join related rows from two tables
SQLite: Match a category key to its display label with an explicit join condition.
SQLite✓ Tested
Join rows in a chosen order
Aggregate text with STRING_AGG and WITHIN GROUP.
STRING_AGG✓ Tested
Join text rows in a chosen order
Combine values using string_agg.
string_agg✓ Tested