The following slides continue discussing the SQL.

Slide 14.1: SQL SELECT statement
Slide 14.2: SQL SELECT DISTINCT statement
Slide 14.3: SQL SELECT WHERE clause
Slide 14.4: SQL SELECT statement
Slide 14.5: SQL SELECT statement (cont.)
Slide 14.6: SQL SELECT statement (cont.)
Slide 14.7: SQL SELECT examples
Slide 14.8: The DISTINCT keyword

Slide 14.9: Arithmetic calculation
Slide 14.10: Using the same table more than once
Slide 14.11: Subqueries
Slide 14.12: The IN predicate
Slide 14.13: The SQL scoping rule
Slide 14.14: The quantified comparison predicate
Slide 14.15: The EXISTS predicate

Slide 14.16: Top SQL joins
Slide 14.17: The (INNER) JOIN clause
Slide 14.18: The LEFT (OUTER) JOIN clause
Slide 14.19: The RIGHT (OUTER) JOIN clause
Slide 14.20: The FULL (OUTER) JOIN clause
Slide 14.21: Pros and cons of SQL JOIN clause
Slide 14.22: A weakness of SQL: Too many equivalent forms

  ☂ References

Slide 14.a: W3Schools’ SQL tutorial






      A problem is a chance for you to do your best.