The Curious Case of the Aggregation Query

This site does not allow itself to be embedded. You can still read it on the original site — the toolbar below keeps your place in the directory.

The Curious Case of the Aggregation Query An interesting query made the rounds recently . The related blog post by Justin Jaffray compares four queries, one of them catching everybody’s attention. I invite you to have a look for yourself. First, the table definitions: CREATE TABLE aa (a INT); INSERT INTO aa VALUES (1), (2), (3); CREATE TABLE xx (x INT); INSERT INTO xx VALUES (10), (20), (30);…

Read on modern-sql.com ↗