Page 14 - SQL

Different Versions of SQL 147
Selection with sorted Results 148

Select columns which are named after reserved keywords 149

Selecting specified number of records 150

Selecting with table alias 151

Select rows from multiple tables 152

Selecting with Aggregate functions 152

Average 152

Minimum 152

Maximum 153

Count 153

Sum 153

Selecting with null 153

Selecting with CASE 154

Selecting without Locking the table 154

Select distinct (unique values only) 155

Select with condition of multiple values from column 155

Get aggregated result for row groups 155

Selecting with more than 1 condition. 156

Chapter 46: Sequence 158

Examples 158

Create Sequence 158

Using Sequences 158

Chapter 47: SKIP TAKE (Pagination) 159

Examples 159

Skipping some rows from result 159

Limiting amount of results 159

Skipping then taking some results (Pagination) 160
Chapter 48: SQL CURSOR 161

Examples 161

Example of a cursor that queries all rows by index for each database 161