Term
| A summary query that counts the number of invoices by vendor |
|
Definition
|
|
Term
| A summary query that includes a final summary row |
|
Definition
|
|
Term
| A summary query that works on non-numeric columns |
|
Definition
|
|
Term
| A summary query that counts unpaid invoices and calculates the total due |
|
Definition
|
|
Term
| A summary query that calculates the average invoice amount by vendor |
|
Definition
|
|
Term
| A summary query that includes a summary row for each set of groups |
|
Definition
|
|
Term
| A summary query with two groups |
|
Definition
|
|
Term
| A summary query that includes a summary row for each grouping level |
|
Definition
|
|
Term
| A summary query that uses the MIN and MAX functions |
|
Definition
|
|
Term
| A summary query that uses the COUNT, AVG, and SUM functions |
|
Definition
|
|
Term
| A summary query that calculates the number of invoices and the average invoice amount for the vendor |
|
Definition
|
|
Term
| A summary query with a search condition in the WHERE clause |
|
Definition
|
|
Term
| A summary query that uses the DISTINCT keyword |
|
Definition
|
|
Term
| A summary query with a composite grouping |
|
Definition
|
|
Term
| A query that calculates a cumulative total and moving average |
|
Definition
|
|
Term
| A summary query with a search condition in the HAVING clause |
|
Definition
|
|
Term
| A summary query that limits the groups to those with two or more invoices |
|
Definition
|
|
Term
| A query that groups the summary data by date |
|
Definition
|
|
Term
| A summary query with a compound condition in the WHERE clause |
|
Definition
|
|
Term
| A summary query with a compound condition in the HAVING clause |
|
Definition
|
|
Term
| A query that calculates a cumulative total and moving average and grouped by TermsID |
|
Definition
|
|
