Why does a LEFT JOIN stop preserving unmatched rows after I add a filter?
See why a right-table filter in WHERE can remove left-side rows, compare both query forms, and choose the one that matches your intended output.
Read the guide 4 min read
GEEZ AT WORK
Technology & devices
Questions, practical answers, and useful follow-ups to help you work through the details.
Latest guides
Showing 577–600 of 845 guides
How can I filter dates to one month without relying on ambiguous date text?
In SQLite, use an inclusive first-day boundary and an exclusive first-day-of-next-month boundary when dates are valid, consistently formatted ISO date text.
Read the guide 4 min read
How do I group SQLite date values by calendar month?
Use SQLite’s strftime('%Y-%m', ...) to create a year-month key, then group and sum by it—provided your stored dates are supported and consistent.
Read the guide 3 min read
How do I summarize rows by category with GROUP BY?
Learn to total a numeric column for each category, interpret the result, and avoid selecting descriptive columns that do not match your grouping.
Read the guide 4 min read
How is HAVING different from WHERE when filtering grouped results?
Learn when to filter transaction rows with WHERE, when to filter group totals with HAVING, and how the two work together.
Read the guide 4 min read
How can I show records that have no related row in another table?
Learn two SQLite anti-join patterns, see the same unmatched members returned by each, and adapt the queries to your relationship columns.
Read the guide 5 min read
When should I use COUNT(*) versus COUNT(column) in SQLite?
Compare SQLite’s row count with its non-NULL value count using hypothetical survey responses, and choose the expression that matches your question.
Read the guide 4 min read
How do I select rows where a column has no value in SQLite?
Use `IS NULL`, not `= NULL`, to find SQLite rows with no stored value; see a corrected query and example results.
Read the guide 4 min read
How can I sort SQLite results predictably when values tie?
See why equal sort values have no specified relative order, and how a unique secondary key makes the intended order explicit.
Read the guide 4 min read
Why does an OR condition return extra rows when I combine it with AND?
See how SQLite groups mixed AND/OR filters, compare the returned task rows, and choose parentheses that match your intended rule.
Read the guide 4 min read
Why does Python import a different module than the one in my project?
Trace the module Python loaded, inspect its search path and launch context, then use a clearer project layout to reduce accidental name collisions.
Read the guide 5 min read
How should I define a small record with dataclasses?
Group related Python values in a compact class, choose sensible defaults, and check whether a dataclass fits your record.
Read the guide 5 min read
How do I filter rows that fall within an inclusive numeric range in SQLite?
Compare SQLite’s two inclusive range forms with a worked price example, including which boundary rows appear in the results.
Read the guide 4 min read
How can I handle a form submission without the page reloading?
Listen for the form’s `submit` event and cancel its default action only when your page code will handle the submission.
Read the guide 4 min read
Why does importing a Python module run its example code?
See why import-time examples run, then move reusable code and command-line behavior into an import-safe Python module.
Read the guide 4 min read
How can I turn a hard-to-reproduce function bug into a small example?
Learn to isolate a Python function failure while keeping the triggering input, expected result, and actual result visible.
Read the guide 5 min read
How do I read the most useful part of a Python traceback?
Start with the exception, then follow traceback frames toward the relevant source line without assuming every frame caused the problem.
Read the guide 4 min read
How can I catch only the exceptions my function can handle?
Learn to replace catch-all handlers with a narrow exception clause, see a before-and-after Python example, and use a checklist to choose what your function should handle.
Read the guide 4 min read
How can I trace which function call produced an unexpected result?
Follow each call from its call site through bound arguments and return values to find where an unexpected result first appears.
Read the guide 5 min read
Why does a function raise UnboundLocalError for a name that exists globally?
Understand why an assignment makes Python treat a name as local, then choose a clear fix with a minimal example and reusable debugging checklist.
Read the guide 4 min read
How can I read JSON arrays of objects and check each record?
Decode the JSON, verify the top-level value is an array, then check each item for required keys and report problems by position without changing the data.
Read the guide 4 min read
Why does my Python function return None when I expected a value?
Learn why printing a result is different from returning it, how to spot the missing return, and how to fix the function.
Read the guide 4 min read
How can I combine small CSV files that share the same headers?
Select the CSV files explicitly, compare their actual headers, then combine their rows and export to a separate output file.
Read the guide 5 min read
How can I save Python data as readable, indented JSON?
Write a Python data structure to a separate UTF-8 JSON file with indentation, then load it again to check the saved data.
Read the guide 4 min read
YOUR QUESTION. YOUR DETAILS.
Let’s work through your situation.
Get a tailored answer or help with your next task. Starts at $1, with a quote before you pay.