Part II. Querying and Updating Data

One statement in particular forms the core of SQL and clearly represents the nonprocedural nature of SQL: the SELECT statement. It is the showpiece of SQL. Some vendors even dare to say that they have implemented SQL when they support only this statement.

This statement is used to query data in the tables; the result is always a table. Such a result table can be used as the basis of a report, for example.

This book deals with the SELECT statement in Chapters 5 to 13. Each chapter is devoted to one or two clauses of this statement. Several chapters have been added to explain certain concepts in more detail.

This part concludes with a chapter that describes how to insert, update, and delete data. The features of ...

Get Introduction to SQL: Mastering the Relational Database Language, Fourth Edition/20th Anniversary 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.