Results for “exec form”

PostgresBulk changes & set operations

Find rows shared by two query results ↗

Postgres: INTERSECT compares complete selected rows and removes duplicates.

Postgres✓ Tested

SQLiteBulk changes & set operations

Find rows shared by two query results ↗

SQLite: INTERSECT compares complete selected rows and removes duplicates.

SQLite✓ Tested

GitCommits & history

Find the commit responsible for a line ↗

Inspect line attribution in a stable machine-readable format.

blame✓ 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

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

SQLiteSubqueries & ranked selection

Find the second-highest distinct value ↗

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

SQLite✓ Tested

PythonGetting Started

Find what remains after division ↗

Python: Use the remainder operator to count items left after forming complete groups.

Python✓ Tested

C#Getting Started

Find what remains after division ↗

C#: Use the remainder operator to count items left after forming complete groups.

C#✓ Tested

JavaGetting Started

Find what remains after division ↗

Java: Use the remainder operator to count items left after forming complete groups.

Java✓ Tested

JavaScriptGetting Started

Find what remains after division ↗

JavaScript: Use the remainder operator to count items left after forming complete groups.

JavaScript✓ Tested