28.4 SQL
We now overview SQL in the context of our books database. You’ll be able to use the SQL discussed here in the examples later in the chapter and in examples in Chapters 30–31.
The next several subsections discuss the SQL keywords listed in Fig. 28.10 in the context of SQL queries and statements. Other SQL keywords are beyond this text’s scope. To learn other keywords, refer to the SQL reference guide supplied by the vendor of the RDBMS you’re using.
Fig. 28.10 SQL query keywords.
| SQL keyword | Description |
|---|---|
| SELECT | Retrieves data from one or more tables. |
| FROM | Tables involved in the query. Required in every SELECT. |
| WHERE | Criteria for selection that determine the rows to be retrieved, deleted or updated. Optional in a SQL ... |
Get Java How to Program (early objects), 9/e 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.
