Results for “Go”
Small, practical examples. Search by task or narrow things down below.
Remove duplicate result values
SQL: Use DISTINCT when repeated category values are not useful.
SQL✓ Tested
Remove duplicate result values
SQL Server: Use DISTINCT when repeated category values are not useful.
SQL Server✓ Tested
Remove duplicate result values
Postgres: Use DISTINCT when repeated category values are not useful.
Postgres✓ Tested
Remove duplicate result values
SQLite: Use DISTINCT when repeated category values are not useful.
SQLite✓ Tested
Require two filtering conditions
SQL: Combine category and quantity conditions with AND.
SQL✓ Tested
Require two filtering conditions
SQL Server: Combine category and quantity conditions with AND.
SQL Server✓ Tested
Require two filtering conditions
Postgres: Combine category and quantity conditions with AND.
Postgres✓ Tested
Require two filtering conditions
SQLite: Combine category and quantity conditions with AND.
SQLite✓ Tested
Search a sorted vector
Use binary_search after ensuring C++ values are sorted.
C++✓ Tested
Sum vector values
Use std::accumulate with a wide initial value.
C++✓ Tested
Turn known group values into columns
SQL: Conditional aggregation gives a portable pivot when the category set is known.
SQL✓ Tested
Turn known group values into columns
SQL Server: Conditional aggregation gives a portable pivot when the category set is known.
SQL Server✓ Tested