Learning More About Queries
Apress eBooks · 2006
SummaryIn this chapter, you learned how to construct more sophisticated queries using the following SQL features: The DISTINCT keyword to eliminate duplicates from the result set Subqueries, which are queries embedded in other queries The IN predicate, using lists of literals and lists returned by subqueries Aggregate functions such as MIN, MAX, SUM, and AVG The GROUP BY clause for categorizing aggregates CASE expressions for providing column values based on logical tests Functions for accessing the components of the datetime data type Inner, outer, and other joins You’ve now looked in closer detail at all the elements of a database that were used in previous chapters. As a result, the next few chapters will sail you into uncharted database territory. You’ll start by learning about two more important database objects that build upon your knowledge of tables and SQL queries: views and stored procedures.