Results for “SELECT”
Small, practical examples. Search by task or narrow things down below.
Read commit subjects affecting one file
Git: Place the path after -- so Git limits history to the selected file.
Git✓ Tested
Read commit subjects from oldest to newest
Git: Reverse the normal newest-first history order.
Git✓ Tested
Read named columns from a table
SQL: Choose the columns needed and request a deterministic row order.
SQL✓ Tested
Read named columns from a table
SQL Server: Choose the columns needed and request a deterministic row order.
SQL Server✓ Tested
Read named columns from a table
Postgres: Choose the columns needed and request a deterministic row order.
Postgres✓ Tested
Read named columns from a table
SQLite: Choose the columns needed and request a deterministic row order.
SQLite✓ Tested
Read stash labels without commit hashes
Git: A custom format provides predictable stash subjects.
Git✓ Tested
Read the final array item with a negative index
JavaScript: at supports negative positions counted from the end.
JavaScript✓ Tested
Read the final array item with a negative index
TypeScript: at supports negative positions counted from the end.
TypeScript✓ Tested
Report duplicate business values and their frequency
SQL: Group by a candidate business key and retain only groups with multiple rows.
SQL✓ Tested
Report duplicate business values and their frequency
SQL Server: Group by a candidate business key and retain only groups with multiple rows.
SQL Server✓ Tested
Report duplicate business values and their frequency
Postgres: Group by a candidate business key and retain only groups with multiple rows.
Postgres✓ Tested