FIND YOUR NEXT FEW LINES

Results for “k”

Small, practical examples. Search by task or narrow things down below.

1871 snippets foundClear filters
SQL ServerWindow analytics

Rank tied scores with competition gaps

SQL Server: RANK leaves a gap after tied rows, unlike DENSE_RANK.

SQL Server✓ Tested
PostgresWindow analytics

Rank tied scores with competition gaps

Postgres: RANK leaves a gap after tied rows, unlike DENSE_RANK.

Postgres✓ Tested
SQLiteWindow analytics

Rank tied scores with competition gaps

SQLite: RANK leaves a gap after tied rows, unlike DENSE_RANK.

SQLite✓ Tested
SQLWindow analytics

Rank tied scores without gaps

SQL: DENSE_RANK assigns equal ranks to ties and increments by one for the next distinct score.

SQL✓ Tested
SQL ServerWindow analytics

Rank tied scores without gaps

SQL Server: DENSE_RANK assigns equal ranks to ties and increments by one for the next distinct score.

SQL Server✓ Tested
PostgresWindow analytics

Rank tied scores without gaps

Postgres: DENSE_RANK assigns equal ranks to ties and increments by one for the next distinct score.

Postgres✓ Tested
SQLiteWindow analytics

Rank tied scores without gaps

SQLite: DENSE_RANK assigns equal ranks to ties and increments by one for the next distinct score.

SQLite✓ Tested
Arduino / CEEPROM & program memory

Read a byte lookup table from flash

Arduino / C: PROGMEM tables require the AVR program-memory access functions.

Arduino / C✓ Tested
Bash ScriptsGetting Started

Read a line without losing backslashes

Bash Scripts: Read a line without losing backslashes with a small standalone Bash program.

Bash Scripts✓ Tested
GoHTTP & URLs

Read a named request cookie

Read a named request cookie using a complete Go program with explicit sample inputs.

Go✓ Tested
SQLSubqueries & ranked selection

Read a page after a known unique key

SQL: A keyset predicate avoids scanning and discarding an increasing offset on a suitable index.

SQL✓ Tested
SQL ServerSubqueries & ranked selection

Read a page after a known unique key

SQL Server: A keyset predicate avoids scanning and discarding an increasing offset on a suitable index.

SQL Server✓ Tested