Contents
1.4 Specifying the maximum number of rows of retrieval results (LIMIT clause)
1.6 Retrieving data with a search range specified (BETWEEN predicate)
1.7 Retrieving data that meets one of multiple conditions (IN predicate)
1.8 Retrieving data that contains a specific character string (LIKE predicate)
1.9 Retrieving data with multiple tables specified (table join)
1.10 Eliminating duplication in retrieval results (SELECT DISTINCT)
1.11 Determining the number of retrieved data items (COUNT(*))
1.12 Determining the maximum, minimum, average, or sum of the retrieved data (set functions)
1.13 Aggregating retrieved data by group (GROUP BY clause, HAVING clause)
1.13.1 Example 1: Determine the number of purchases for each customer
1.13.2 Example 2: Determine the number of sales for each product code
1.13.3 Example 3: Determine the sum and average of the quantities purchased for each product code
1.13.5 Example 5: Aggregate data from the sales history table and customer table
1.14 Retrieving by specifying a SELECT statement in the search condition (subquery)
1.15 Common errors in SQL statements and how to handle them