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.

Google Online Preview   Download