Page 11 - SQL
P. 11
Inner Join 113
Left outer join 113
Right outer join 113
Full outer join 113
JOIN Terminology: Inner, Outer, Semi, Anti... 113
Inner Join 113
Left Outer Join 113
Right Outer Join 113
Full Outer Join 113
Left Semi Join 113
Right Semi Join 113
Left Anti Semi Join 113
Right Anti Semi Join 114
Cross Join 114
Self-Join 115
Chapter 36: LIKE operator 116
Syntax 116
Remarks 116
Examples 116
Match open-ended pattern 116
Single character match 118
Match by range or set 118
Match ANY versus ALL 119
Search for a range of characters 119
ESCAPE statement in the LIKE-query 119
Wildcard characters 120
Chapter 37: Materialized Views 122
Introduction 122
Examples 122
PostgreSQL example 122
