Loading page...
Q&A
Q&AAnalytic functions calculate across a partition while keeping each input row in the result.
GROUP BY collapses rows into one row per group. An analytic function uses OVER with partition, ordering, and frame rules to calculate a value while preserving row detail. Specify a deterministic ordering and explicit frame for running totals when peer-row behavior would matter.
Q&A
Q&AWHERE filters input rows before grouping; HAVING filters groups after aggregation.
Use WHERE to remove rows before GROUP BY, such as excluding inactive employees. Use HAVING to filter aggregate results, such as departments with COUNT(*) greater than five. Moving a condition between them can change both meaning and query work.
databases
10 minUse Oracle analytic SQL for ordered calculations, inspect plan operations, and understand why bind-variable behavior matters.
Q&A
Q&AIt cancels unfinished siblings, waits for cleanup, and surfaces failures as a group.
Child cancellation is cooperative, so cleanup must run and cancellation should normally be re-raised. A task group scopes lifetimes; it does not roll back remote effects or make partial success a business policy.
distributed systems
18 minDesign around Kafka group churn, payment idempotency, coordination limits, sagas, CQRS, and context propagation across async boundaries.
Q&A
Q&ACOUNT(column) excludes NULL values; COUNT(*) counts input rows.
COUNT(*) counts each row in the group regardless of column values. COUNT(column) counts only rows where that expression is non-NULL. When aggregates look low, check nullability and join multiplication before changing the query.
python
8 minUnderstand structured task lifetimes, cancellation, and grouped failures in asyncio.
Q&A
Q&AAssociativity and an identity element make regrouping partial results meaningful.
A parallel reduction may group values differently, so its combine operation should be associative for equivalent results and have a suitable identity value. Floating-point addition can vary slightly with grouping. Avoid reducers with hidden side effects because execution order may not be stable.