SQL Aggregate Functions - Documentation & Help
SQL Aggregate Functions
Using the SQL aggregate functions, you can determine various statistics on sets of values. You can use these functions in a query and aggregate expressions in the SQL property of a QueryDef object or when creating a Recordset object based on an SQL query. Avg Function Count Function First, Last Functions Min, Max Functions StDev, StDevP Functions Sum Function Var, VarP Functions
SQL Expressions
An SQL expression is a string that makes up all or part of an SQL statement. For example, the FindFirst method on a Recordset object uses an SQL expression consisting of the selection criteria found in an SQL WHERE clause.
The Microsoft Jet database engine uses the Microsoft? Visual Basic? for Applications (or VBA) expression service to perform simple arithmetic and function evaluation. All of the operators used in Microsoft Jet SQL expressions (except Between, In, and Like) are defined by the VBA expression service. In addition, the VBA expression service offers over 100 VBA functions that you can use in SQL expressions. For example, you can use these VBA functions to compose an SQL query in the Microsoft Access query Design view, and you can also use these functions in an SQL query in the DAO OpenRecordset method in Microsoft Visual C++?, Microsoft Visual Basic, and Microsoft Excel code.
SQL Reserved Words
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
The following list includes all words reserved by the Microsoft Jet database engine for use in SQL statements. The words in the list that are not in all uppercase letters are also reserved by other applications. Consequently, the individual Help topics for these words provide general descriptions that do not focus on SQL usage.
Note Words followed by an asterisk (*) are reserved but currently have no meaning in the context of a Microsoft? Jet SQL statement (for example, Level and TableID). Words that are not underlined do not have linked explanations.
A
ABSOLUTE ADD ADMINDB ALL Alphanumeric -- See TEXT ALTER ALTER TABLE And AS
B-C
BEGIN Between BINARY BIT BIT_LENGTH BOOLEAN -- See BIT BOTH BY
ANY ARE AS ASC ASSERTION AUTHORIZATION AUTOINCREMENT -- See COUNTER Avg
COLLATION COLUMN COMMIT COMP, COMPRESSION CONNECT CONNECTION CONSTRAINT, CONSTRAINTS CONTAINER
BYTE CASCADE CATALOG CHAR, CHARACTER -- See TEXT CHAR_LENGTH CHARACTER_LENGTH CHECK CLOSE CLUSTERED COALESCE COLLATE
D
DATABASE DATE -- See DATETIME DATETIME DAY DEC, DECIMAL DECLARE DELETE DESC
E-H
Eqv EXCLUSIVECONNECT EXEC, EXECUTE EXISTS EXTRACT FALSE FETCH
CONTAINS CONVERT Count COUNTER
CREATE CURRENCY CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR
DISALLOW DISCONNECT DISTINCT DISTINCTROW DOMAIN DOUBLE DROP
FOREIGN FROM FROM Clause GENERAL -- See LONGBINARY GRANT GROUP GUID
FIRST
HAVING
FLOAT, FLOAT8 -- See DOUBLE HOUR
FLOAT4 -- See SINGLE
I
IDENTITY IEEEDOUBLE -- See DOUBLE IEEESINGLE -- See SINGLE IGNORE IMAGE
Imp In IN INDEX INDEXCREATEDB INNER
INPUT INSENSITIVE INSERT INSERT INTO INT, INTEGER, INTEGER4 -- See LONG INTEGER1 -- See BYTE INTEGER2 -- See SHORT INTERVAL INTO Is ISOLATION
J-M
JOIN
LONGTEXT
KEY
LOWER
LANGUAGE
MATCH
LAST
Max
LEFT
MEMO -- See LONGTEXT
Level*
Min
Like
MINUTE
LOGICAL, LOGICAL1 -- See BIT Mod
LONG
MONEY -- See CURRENCY
LONGBINARY
MONTH
LONGCHAR
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- to char function with dates
- sql convert varchar to float example
- microsoft sql server
- conversion functions
- converting entity attribute value eav source tables into
- sql aggregate functions documentation help
- t sql data types
- oracle to bigquery sql translation reference
- convert int to string sql server example
Related searches
- cannot mix aggregate and non aggregate case
- aggregate and non aggregate tableau
- aggregate vs non aggregate deductible
- aggregate vs non aggregate tableau
- pandas aggregate functions list
- db2 sql functions list
- db2 sql functions reference
- aggregate functions in pandas
- cannot mix aggregate and non aggregate tableau
- aggregate functions in pandas dataframe
- aggregate functions in python
- access sql functions list