Java Reference
In-Depth Information
Using
SELECT FROM
to retrieve all rows and columns from a table
Using the
WHERE
clause to retrieve rows matching a specific query
Using the
ORDER BY
clause to sort the returned data
SQL Operators
Escape sequences
Subqueries using the keywords:
EXISTS
and NOT EXISTS
ANY and ALL
IN
and
NOT IN
Nested and correlated subqueries
JDBC
ResultSets
and
ResultSetMetaData
The
next chapter
discusses using joins to retrieve data from more than one table.