Page 9 - SQL
P. 9
Grant/revoke privileges 85
Chapter 29: GROUP BY 86
Introduction 86
Syntax 86
Examples 86
USE GROUP BY to COUNT the number of rows for each unique entry in a given column 86
Filter GROUP BY results using a HAVING clause 88
Basic GROUP BY example 88
ROLAP aggregation (Data Mining) 89
Description 89
Examples 90
With cube 90
With roll up 90
Chapter 30: Identifier 92
Introduction 92
Examples 92
Unquoted identifiers 92
Chapter 31: IN clause 93
Examples 93
Simple IN clause 93
Using IN clause with a subquery 93
Chapter 32: Indexes 94
Introduction 94
Remarks 94
Examples 94
Creating an Index 94
Clustered, Unique, and Sorted Indexes 95
Inserting with a Unique Index 96
SAP ASE: Drop index 96
Sorted Index 96
Dropping an Index, or Disabling and Rebuilding it 96
Unique Index that Allows NULLS 97
