Results for “not”
Small, practical examples. Search by task or narrow things down below.
Read the last value of the complete partition
SQL: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.
SQL✓ Tested
Read the last value of the complete partition
SQL Server: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.
SQL Server✓ Tested
Read the last value of the complete partition
Postgres: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.
Postgres✓ Tested
Read the last value of the complete partition
SQLite: Specify an unbounded-following frame so LAST_VALUE does not stop at the current row.
SQLite✓ Tested
Reject a negative quantity with CHECK
SQL: Combine NOT NULL and CHECK because an unknown NULL check result is normally accepted.
SQL✓ Tested
Reject a negative quantity with CHECK
SQL Server: Combine NOT NULL and CHECK because an unknown NULL check result is normally accepted.
SQL Server✓ Tested
Reject a negative quantity with CHECK
Postgres: Combine NOT NULL and CHECK because an unknown NULL check result is normally accepted.
Postgres✓ Tested
Reject a negative quantity with CHECK
SQLite: Combine NOT NULL and CHECK because an unknown NULL check result is normally accepted.
SQLite✓ Tested
Reject an unsupported settings version
Arduino / C: A version byte lets firmware fall back when stored settings use another format.
Arduino / C✓ Tested
Remove a filename extension
Keep the path while removing its final extension.
filename✓ Tested
Remove an empty directory only
Linux Commands: Use rmdir so a directory containing files cannot be removed accidentally.
Linux Commands✓ Tested
Remove duplicate result values
SQL: Use DISTINCT when repeated category values are not useful.
SQL✓ Tested