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 37

Nesting Levels in SQL

Abstract

SQL is a block-structured language with scoping rules, but these rules are not like other languages.

Keywords

Dijkstra

Yourdon

DeMacro

Software engineering

“Structured Programming”

“Structured Analysis”

Derived table

LATERAL table

Heuristics

The ancestor of SQL was an IBM project named Sequel, which was a shorthand for “Structured English Query Language”; the term “Structured” in the name came from two sources. The first was the “Structured Revolution” at the time. Dijkstra, Youron, DeMacro, and the other early pioneers of modern Software Engineering had just given us “Structured Programming” and “Structured Analysis,” so everything had to be Structured. Younger people will remember when everything ...

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