Results for “related rows”
Small, practical examples. Search by task or narrow things down below.
Find the nearest matching ancestor
Read a parent row attribute using jQuery closest.
jQuery✓ Tested
Find the second-highest distinct value
SQL: Select the maximum below the overall maximum to skip ties at the top.
SQL✓ Tested
Find the second-highest distinct value
SQL Server: Select the maximum below the overall maximum to skip ties at the top.
SQL Server✓ Tested
Find the second-highest distinct value
Postgres: Select the maximum below the overall maximum to skip ties at the top.
Postgres✓ Tested
Find the second-highest distinct value
SQLite: Select the maximum below the overall maximum to skip ties at the top.
SQLite✓ Tested
Finish all queued animations immediately
jQuery: finish jumps current and queued animations to their final values.
jQuery✓ Tested
Focus an input through a ref
Focus an input through a ref with a small React component and explicit browser behavior.
React✓ Tested
Focus an input through its template reference
Focus an input through its template reference with a standalone Angular component and explicit browser behavior.
Angular✓ Tested
Format a date in an explicit timezone
Format a date in an explicit timezone with a standalone Angular component and explicit browser behavior.
Angular✓ Tested
Format a fractional value as a percentage
Format a fractional value as a percentage with a standalone Angular component and explicit browser behavior.
Angular✓ Tested
Format a number with fixed decimal places
Format a number with fixed decimal places with a standalone Angular component and explicit browser behavior.
Angular✓ Tested
Format a timestamp
Extract a year and month from ISO timestamp text.
strftime✓ Tested