</>SnippetSearch. A little code. A lot of possibility.
FIND YOUR NEXT FEW LINES

Results for “ROW_NUMBER”

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

1221 snippets foundClear filters
SQLiteGetting Started

Find missing values with IS NULL

SQLite: Use IS NULL rather than equality to test for missing data.

SQLite✓ Tested
SQLRelationships & missing data

Find parents whose every child meets a rule

SQL: Combine existence with the absence of a violating child to exclude parents with no children.

SQL✓ Tested
SQL ServerRelationships & missing data

Find parents whose every child meets a rule

SQL Server: Combine existence with the absence of a violating child to exclude parents with no children.

SQL Server✓ Tested
PostgresRelationships & missing data

Find parents whose every child meets a rule

Postgres: Combine existence with the absence of a violating child to exclude parents with no children.

Postgres✓ Tested
SQLiteRelationships & missing data

Find parents whose every child meets a rule

SQLite: Combine existence with the absence of a violating child to exclude parents with no children.

SQLite✓ Tested
SQL ServerDates & text

Find the final day of a month

Use EOMONTH without manually calculating month length.

EOMONTH✓ Tested
SQLiteDates & time

Find the first day of a month

Round a date to its calendar month boundary.

date✓ Tested
C++Numbers & algorithms

Find the largest value

Check for an empty C++ vector before dereferencing max_element.

C++✓ Tested
jQueryTraversal & selection

Find the nearest matching ancestor

Read a parent row attribute using jQuery closest.

jQuery✓ Tested
SQLSubqueries & ranked selection

Find the second-highest distinct value

SQL: Select the maximum below the overall maximum to skip ties at the top.

SQL✓ Tested
SQL ServerSubqueries & ranked selection

Find the second-highest distinct value

SQL Server: Select the maximum below the overall maximum to skip ties at the top.

SQL Server✓ Tested
PostgresSubqueries & ranked selection

Find the second-highest distinct value

Postgres: Select the maximum below the overall maximum to skip ties at the top.

Postgres✓ Tested