O'Reilly logo

Joe Celko's SQL for Smarties, 5th Edition by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 26

Advanced SELECT Statements

Abstract

This is a collection of common SQL programming idioms for queries. We show how correlated subqueries are used and discuss the ANSI/ISO Standard infixed join operators. The chapter covers replacing missing values in columns and rows. There is a detailed Stable Marriages solution.

Keywords

“Data Smear”

Aggregate functions

Algol

Best-fit greedy algorithm

Block structured languages

Box Packing

Combinatorial explosions

Comparisons

Correlation

CROSS JOIN

CUBE

Daniel Morgan

DEFAULT

Derived table

Donald E. Knuth

Duplicate rows

Dwain Camps

Edsger Dijkstra

Frédéric Brouard

FULL OUTER JOIN

GOTO statement

Greedy algorithm

GROUPING < column name >

GROUPING SET

Gusfierld Dan Irving

INNER JOIN

Interpolation ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required