SQL Reference
Manuals
Brands
Claris FileMaker Manuals
Applications
FileMaker Pro 14
1
2
3
4
5
6
7
8
9
10
Table Of Contents
Contents
Chapter 1 Introduction
About this reference
Where to find FileMaker documentation
About SQL
Using a FileMaker database as a data source
Using the ExecuteSQL function
Chapter 2 Supported standards
Support for Unicode characters
SQL statements
SELECT statement
SQL clauses
FROM clause
WHERE clause
GROUP BY clause
HAVING clause
UNION operator
ORDER BY clause
OFFSET and FETCH FIRST clauses
FOR UPDATE clause
DELETE statement
INSERT statement
UPDATE statement
CREATE TABLE statement
ALTER TABLE statement
CREATE INDEX statement
DROP INDEX statement
SQL expressions
Field names
Constants
Exponential/scientific notation
Numeric operators
Character operators
Date operators
Relational operators
Logical operators
Operator precedence
SQL functions
Aggregate functions
Functions that return character strings
Functions that return numbers
Functions that return dates
Conditional functions
Reserved SQL keywords
Index
4
SQL functions
28
Aggregate fu
nctions
28
Functions that return character strings
29
Functions that return numbers
30
Functions that return dates
32
Conditional functions
32
Reserved SQL keywords
34
Index
37
1
...
2
3
4
5
6
...
...
39
