Page 13 - SQL
P. 13
PROJECT 136
GIVING 136
NATURAL JOIN 137
ALIAS 138
DIVIDE 138
UNION 138
INTERSECTION 138
DIFFERENCE 138
UPDATE ( := ) 138
TIMES 138
Chapter 44: Row number 140
Syntax 140
Examples 140
Row numbers without partitions 140
Row numbers with partitions 140
Delete All But Last Record (1 to Many Table) 140
Chapter 45: SELECT 141
Introduction 141
Syntax 141
Remarks 141
Examples 141
Using the wildcard character to select all columns in a query. 141
Simple select statement 142
Dot notation 142
When Can You Use *, Bearing The Above Warning In Mind? 143
Selecting with Condition 144
Select Individual Columns 144
SELECT Using Column Aliases 145
All versions of SQL 145
Different Versions of SQL 146
All Versions of SQL 147
