Page 16 - SQL
P. 16
Chapter 53: Subqueries 176
Remarks 176
Examples 176
Subquery in WHERE clause 176
Subquery in FROM clause 176
Subquery in SELECT clause 176
Subqueries in FROM clause 176
Subqueries in WHERE clause 177
Subqueries in SELECT clause 177
Filter query results using query on different table 178
Correlated Subqueries 178
Chapter 54: Synonyms 179
Examples 179
Create Synonym 179
Chapter 55: Table Design 180
Remarks 180
Examples 180
Properties of a well designed table. 180
Chapter 56: Transactions 182
Remarks 182
Examples 182
Simple Transaction 182
Rollback Transaction 182
Chapter 57: Triggers 183
Examples 183
CREATE TRIGGER 183
Use Trigger to manage a "Recycle Bin" for deleted items 183
Chapter 58: TRUNCATE 184
Introduction 184
Syntax 184
Remarks 184
Examples 184
