'Select avg sal' presentation slideshows

Aggregating Data Using Group Functions

Aggregating Data Using Group Functions. Objectives. After completing this lesson, you should be able to do the following: Identify the available group functions Describe the use of group functions Group data using the GROUP BY clause

545 views • 44 slides

Chapter 12: When One Query Depends Upon Another

Chapter 12: When One Query Depends Upon Another. Correlated Subqueries. Subqueries in the where clause. Anti-Joins. Using NOT IN or NOT EXISTS with a subquery. Outer Joins. Special type of join between tables where matching data not found.

333 views • 15 slides

Advanced SQL

217 views • 8 slides