Page 6 - SQL
P. 6
Customers 44
Cars 45
Library Database 46
Relationships between tables 46
Authors 46
Books 47
BooksAuthors 48
Examples 49
Countries Table 49
Countries 49
Chapter 18: EXCEPT 51
Remarks 51
Examples 51
Select dataset except where values are in this other dataset 51
Chapter 19: Execution blocks 52
Examples 52
Using BEGIN ... END 52
Chapter 20: EXISTS CLAUSE 53
Examples 53
EXISTS CLAUSE 53
Get all customers with a least one order 53
Get all customers with no order 53
Purpose 54
Chapter 21: EXPLAIN and DESCRIBE 55
Examples 55
DESCRIBE tablename; 55
EXPLAIN Select query 55
Chapter 22: Filter results using WHERE and HAVING 56
Syntax 56
Examples 56
The WHERE clause only returns rows that match its criteria 56
