Site MapHelpFeedbackAdvanced Query Formulation with SQL
Advanced Query Formulation with SQL


As the first chapter in Part 5 of the textbook, this chapter builds on material covered in Chapter 4. Chapter 4 provided a foundation for query formulation using SQL. Most importantly, you learned an important subset of the SELECT statement and usage of the SELECT statement to problems involving joins and grouping. This chapter extends your knowledge of query formulation to advanced matching problems. To solve these advanced matching problems, additional parts of the SELECT statement are introduced.

This chapter continues with the learning approaches of Chapter 4: provide many examples to imitate and problem-solving guidelines to help you reason through difficult problems. You first will learn to formulate problems involving the outer join operator using new keywords in the FROM clause. Next you will learn to recognize nested queries and apply them to formulate problems involving the join and difference operators. Then you will learn to recognize problems involving the division operator and formulate them using the GROUP BY clause, nested queries in the HAVING clause, and the COUNT function. Finally, you will learn the effect of null values on simple conditions, compound conditions with logical operators, aggregate calculations, and grouping.

The presentation in this chapter covers additional features in Core SQL:2003, especially features not part of SQL-92. All examples execute in recent versions of Microsoft Access (2002 and beyond) and Oracle (9i and beyond) except where noted.








To learn more about the book this website supports, please visit its Information Center.
(c)2007 McGraw-Hill Higher Education
Any use is subject to the Terms of Use and Privacy Policy.
McGraw-Hill Higher Education is one of the many fine businesses of The McGraw-Hill Companies.


Mannino DB Design 3eOnline Learning Center with Powerweb

Home > Chapter 9