| |
Home |
Return to Collection List
Enable Frames
| Transact-SQL® User's Guide |
| About This Book |
![[+]](/dwicons/i_expand.gif)
| Chapter 1 SQL Building Blocks |
|
| Chapter 2 Queries: Selecting Data from a Table |
![[-]](/dwicons/i_colpse.gif)
| Chapter 3 Using Aggregates, Grouping, and Sorting |
|
| Using aggregate functions |
|
| Organizing query results into groups: the group by clause |
|
| Selecting groups of data: the having clause |
|
| Sorting query results: the order by clause |
|
|
|
|
| Row aggregates and compute |
| Specifying more than one column after compute |
| Using more than one compute clause |
| Applying an aggregate to more than one column |
| Using different aggregates in the same compute clause |
| Grand values: compute without by |
|
| Combining queries: the union operator |
|
| Chapter 4 Joins: Retrieving Data from Several Tables |
|
| Chapter 5 Subqueries: Using Queries Within Other Queries |
|
| Chapter 6 Using and Creating Datatypes |
|
| Chapter 7 Creating Databases and Tables |
|
| Chapter 8 Adding, Changing, and Deleting Data |
|
| Chapter 9 Views: Limiting Access to Data |
|
| Chapter 10 Using the Built-In Functions in Queries |
|
| Chapter 11 Creating Indexes on Tables |
|
| Chapter 12 Defining Defaults and Rules for Data |
|
| Chapter 13 Using Batches and Control-of-Flow Language |
|
| Chapter 14 Using Stored Procedures |
|
| Chapter 15 Using Extended Stored Procedures |
|
| Chapter 16 Triggers: Enforcing Referential Integrity |
|
| Chapter 17 Cursors: Accessing Data Row by Row |
|
| Chapter 18 Transactions: Maintaining Data Consistency and Recovery |
|
| Chapter 19 Locking Commands and Options |
|
| Appendix A The pubs2 Database |
|
| Appendix B The pubs3 Database |