24.4 SQL
We now discuss 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. The next several subsections demonstrate SQL queries and statements using the SQL keywords in Fig. 24.10. Other SQL keywords are beyond this text’s scope.
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 statement. |
GROUP BY |
Criteria for grouping rows. Optional in a SELECT query. |
ORDER BY |
Criteria for ordering rows. Optional in a SELECT query. |
INNER JOIN |
Merge rows from multiple tables. |
Get Java How to Program, Early Objects, 11th 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.