FIND YOUR NEXT FEW LINES
Results for “function”
Small, practical examples. Search by task or narrow things down below.
124 snippets foundClear filters
Select the top row in each group with a tie-breaker
SQL Server: Filter an outer query on ROW_NUMBER because window functions are not evaluated in WHERE.
SQL Server✓ Tested
Select the top row in each group with a tie-breaker
Postgres: Filter an outer query on ROW_NUMBER because window functions are not evaluated in WHERE.
Postgres✓ Tested
Select the top row in each group with a tie-breaker
SQLite: Filter an outer query on ROW_NUMBER because window functions are not evaluated in WHERE.
SQLite✓ Tested
Transform each item in a collection
Build a result array with a foreach expression.
foreach✓ Tested