Page 8 - SQL
P. 8
SQL Server 69
SQL Server 2016 and earlier 70
SQL Server 2017 and SQL Azure 70
SQLite 70
Count 70
Max 72
Min 72
Chapter 26: Functions (Analytic) 73
Introduction 73
Syntax 73
Examples 73
FIRST_VALUE 73
LAST_VALUE 74
LAG and LEAD 74
PERCENT_RANK and CUME_DIST 75
PERCENTILE_DISC and PERCENTILE_CONT 76
Chapter 27: Functions (Scalar/Single Row) 79
Introduction 79
Syntax 79
Remarks 79
Examples 80
Character modifications 80
Date And Time 80
Configuration and Conversion Function 82
Logical and Mathmetical Function 83
SQL has two logical functions – CHOOSE and IIF. 83
SQL includes several mathematical functions that you can use to perform calculations on in 84
Chapter 28: GRANT and REVOKE 85
Syntax 85
Remarks 85
Examples 85
