D426 Chapter 3 study note correctly solved 2026/2027

D426 Chapter 3
Study online at https://quizlet.com/_e6qhnc

1. IN Used in a WHERE clause to determine if a value matches one of several values.

2. BETWEEN Provides an alternative way to determine a value is between two other values.

3. LIKE Used in a WHERE clause, matches text against a pattern using the two
wildcard characters % and _

4. DISTINCT Used with a SELECT statement to return only unique values.

5. ORDER BY Orders selected rows by one or more columns in ascending (alphabetic or increas-
ing) order.

6. DESC keyword with the ORDER BY clause orders rows in descending order.

7. Aggregate Processes values from a set of rows and returns a summary value.
Func-tion

8. COUNT() Counts the number of rows in a set.

9. MIN() Finds the minimum value in the set.

10. MAX() Finds the maximum value in the set.

11. SUM() Sums all the values in the set.

12. AVG() Computes the arithmetic mean of all the values in the set.

13. HAVING Is used with the GROUP BY clause to filter group results.

14. INNER JOIN Selects only matching left and right table rows.

15. FULL JOIN Selects all left and right table rows, regardless of match.

16. LEFT JOIN Selects all left table rows, but only matching right table rows.

17. RIGHT JOIN Selects all right table rows, but only matching left table rows.
1/3