Page 7 - SQL
P. 7
Use IN to return rows with a value contained in a list 56
Use LIKE to find matching strings and substrings 56
WHERE clause with NULL/NOT NULL values 57
Use HAVING with Aggregate Functions 58
Use BETWEEN to Filter Results 58
Equality 59
AND and OR 60
Use HAVING to check for multiple conditions in a group 61
Where EXISTS 62
Chapter 23: Finding Duplicates on a Column Subset with Detail 63
Remarks 63
Examples 63
Students with same name and date of birth 63
Chapter 24: Foreign Keys 64
Examples 64
Creating a table with a foreign key 64
Foreign Keys explained 64
A few tips for using Foreign Keys 65
Chapter 25: Functions (Aggregate) 66
Syntax 66
Remarks 66
Examples 67
SUM 67
Conditional aggregation 67
AVG() 68
EXAMPLE TABLE 68
QUERY 68
RESULTS 69
List Concatenation 69
MySQL 69
Oracle & DB2 69
PostgreSQL 69
