Java Reference
In-Depth Information
Name
Items
Total
Corleone, Francis
2
7.42
Corleone, Fredo
4
12.92
Corleone, Vito
2
13.45
This result set always reflects the underlying table; if Fredo Corleone were to buy a huge supply of
chocolate chip cookies, the next time you run the same query, you might see a result set like this one:
Name
Items
Total
Adams, Kay
3
6.96
Corleone, Francis
2
7.42
Corleone, Fredo
4
135.14
Corleone, Vito
2
13.45
Note
Views are a way of saving queries by name, which can be very useful for creating reports
or updates you want to use on a regular basis. The database management system
generally saves the view by associating the
SELECT
statement with the view name and
executing it when you want to access the view.
Summary
In this chapter, you learn to perform the following tasks:
Sorting the data you retrieve from a database
Grouping the results for analysis
Performing statistical analyses on the data you retrieve from a database
Create and use indexes to improve performance
Saving your queries as views
In the
next chapter
, you learn to retrieve data from more than one table.
