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 ...
Get Joe Celko's SQL for Smarties, 5th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
