Skip to content
Tagged articles

aggregate functions

4 articles · Page 1 of 1
Java Tech Enthusiast
Java Tech Enthusiast
Oct 4, 2026 · Databases

Why SQL NULL Can't Use Equals: Three-Valued Logic & Hidden Pitfalls

This article explains why SQL NULL represents an unknown state rather than a value, how three-valued logic (TRUE, FALSE, UNKNOWN) breaks equality comparisons, and demonstrates practical pitfalls with WHERE clauses, NOT IN subqueries, aggregate functions, and MySQL's NULL-safe operator.

MySQLNOT IN pitfallNULL
0 likes · 9 min read
Why SQL NULL Can't Use Equals: Three-Valued Logic & Hidden Pitfalls
ITPUB
ITPUB
Mar 18, 2017 · Databases

Mastering SQL Server Aggregate Functions: Optimization Tips and Techniques

This article explains SQL Server aggregate functions, detailing scalar and hash aggregation concepts, demonstrates execution‑plan analysis with COUNT examples, and provides practical optimization techniques such as avoiding sorting and adding non‑clustered indexes, while also covering monitoring metrics for performance tuning.

SQL ServerScalar Aggregationaggregate functions
0 likes · 9 min read
Mastering SQL Server Aggregate Functions: Optimization Tips and Techniques
ITPUB
ITPUB
Apr 3, 2016 · Databases

Master SQL GROUP BY: From Simple Aggregations to Rollup and Joins

This guide explains how to use SQL's GROUP BY clause with examples covering basic grouping, GROUP_CONCAT, aggregate functions, HAVING filters, multi‑column grouping, WITH ROLLUP, and inner, left, and right joins, illustrating each technique with clear query results.

HAVINGSQLWITH ROLLUP
0 likes · 7 min read
Master SQL GROUP BY: From Simple Aggregations to Rollup and Joins