FileMaker SQL Reference

Transcription

1 FileMaker 13 SQL

2 2013 FileMaker, Inc. All Rights Reserved. FileMaker, Inc Patrick Henry Drive Santa Clara, California FileMaker Bento FileMaker, Inc. FileMaker WebDirect Bento FileMaker, Inc. FileMaker FileMaker, Inc. FileMaker E URL E URL Acknowledgements URL FileMaker, Inc. 01

3 1 5 5 PDF 5 SQL 5 FileMaker 6 ExecuteSQL Unicode 7 SQL 7 SELECT 8 SQL 8 FROM 9 WHERE 9 GROUP BY 10 HAVING 10 UNION 11 ORDER BY 11 OFFSET FETCH FIRST 11 FOR UPDATE 12 DELETE 15 INSERT 15 UPDATE 16 CREATE TABLE 17 ALTER TABLE 18 CREATE INDEX 19 DROP INDEX 19 SQL

4 4 SQL SQL 29 32

5 1 FileMaker Pro SQL SQL FileMaker ODBC JDBC ODBC JDBC FileMaker Pro [ExecuteSQL] FileMaker Pro SQL FileMaker ODBC JDBC SQL FileMaker Pro [ExecuteSQL] SELECT 1 FileMaker Pro ODBC JDBC 1 FileMaker Pro ODBC JDBC SQL 1 FileMaker Pro Advanced FileMaker Pro FileMaker Pro FileMaker Pro Advanced PDF FileMaker PDF 1 FileMaker Pro [ ] > [ ] 1 FileMaker Server [ ] > [FileMaker Server ] 1 Web SQL SQL SELECT SQL SQL FileMaker SQL 2

6 1 6 FileMaker FileMaker ODBC JDBC FileMaker ODBC JDBC FileMaker FileMaker ODBC JDBC SQL FileMaker FileMaker ODBC JDBC FileMaker ODBC JDBC FileMaker ODBC JDBC SQL ExecuteSQL FileMaker Pro [ExecuteSQL] [ExecuteSQL] [ExecuteSQL] [ExecuteSQL] [ExecuteSQL] [ExecuteSQL] [ExecuteSQL] SELECT 8 SELECT ExecuteSQL {} SQL-92 ISO [ExecuteSQL] ODBC/JDBC [ExecuteSQL] FileMaker Pro

7 2 FileMaker SQL FileMaker ODBC JDBC SQL FileMaker Pro [ExecuteSQL] SELECT ODBC JDBC FileMaker FileMaker FileMaker Pro FileMaker Server 1 ODBC Level 2 ODBC 3.5 Level 1 1 JDBC JDBC ODBC JDBC SQL-92 SQL-92 Unicode ODBC JDBC Unicode API Unicode ASCII Unicode SQL_C_WCHAR SQL ODBC JDBC SQL 1 SELECT8 1 DELETE15 1 INSERT15 1 UPDATE16 1 CREATE TABLE17 1 ALTER TABLE18 1 CREATE INDEX19 1 DROP INDEX19 FileMaker ODBC SQL JDBC SQL FileMaker ODBC JDBC SQL ODBC JDBC FileMaker ("")

8 2 8 SELECT SELECT SELECT * 1.05 SELECT SELECT [DISTINCT] {* [[AS] ],...} FROM [ ],... [ WHERE 1 2 ] [ GROUP BY {,...}] [ HAVING 1 2 ] [ UNION [ALL] (SELECT...)] [ ORDER BY { [DESC ASC]},...] [ OFFSET n {ROWS ROW} ] [ FETCH FIRST [ n [ PERCENT ] ] { ROWS ROW } {ONLY WITH TIES } ] [ FOR UPDATE [OF {,...}] ] [] SELECT " " AS " " FROM " ".. DISTINCT SELECT DISTINCT " " FROM " " SQL ODBC JDBC SQL SQL FROM9 WHERE9 GROUP BY10 HAVING10 UNION11 ORDER BY11 OFFSET11 SELECT FileMaker Pro FileMaker Pro 20,000,000 SELECT FETCH FIRST11 FOR UPDATE12 SQL SELECT

9 2 9 FROM FROM SELECT FROM [ ] [, [ ]] ExecuteSQL SELECT " " FROM " " FROM E E. SELECT SELECT * FROM " " "E", " " "F" WHERE "E"." " = "F"." " = INNER JOIN SELECT * FROM " " INNER JOIN " " ON " "." " = " "." " LEFT OUTER JOIN SELECT * FROM " " LEFT OUTER JOIN " " ON " "." " = " "." " 1 RIGHT OUTER JOIN 1 FULL OUTER JOIN WHERE WHERE WHERE WHERE SELECT 2,000,000 SELECT " "," " FROM " " WHERE " " >=

10 2 10 WHERE WHERE 1 IS NULL WHERE NOT 2 SELECT WHERE GROUP BY GROUP BY GROUP BY SELECT SELECT " ", SUM ( " " ) FROM " " GROUP BY " " HAVING HAVING 20,000,000 HAVING SELECT 20,000,000 SELECT " ", SUM ( " " ) FROM " " GROUP BY " " HAVING SUM ( " " ) >

11 2 11 UNION UNION SELECT SELECT ALL UNION ALL SELECT UNION [ALL] SELECT UNION SELECT SELECT " ", " ", " " FROM " " UNION SELECT " ", " ", " " FROM " " SELECT SELECT " ", " " FROM " " UNION SELECT " ", " " FROM " " ORDER BY ORDER BY ORDER BY { [DESC ASC]},... ASC SELECT SELECT " ", " ", " " FROM " " ORDER BY " ", " " SELECT " ", " ", " " FROM " " ORDER BY 2, 3 2 SELECT ORDER BY 2 OFFSET FETCH FIRST OFFSET FETCH FIRST OFFSET OFFSET SELECT 0 FETCH FIRST OFFSET OFFSET FETCH FIRST SELECT OFFSET OFFSET FETCH FIRST

12 2 12 OFFSET OFFSET [ OFFSET n {ROWS ROW} ] n n ROWS ROW FETCH FIRST FETCH FIRST FETCH FIRST [ n [ PERCENT ] ] { ROWS ROW } {ONLY WITH TIES } ] n n PERCENT n n PERCENT ROWS ROW WITH TIES ORDER BY WITH TIES ORDER BY FETCH 26 SELECT SELECT " ", " ", " " FROM " " ORDER BY " ", " " OFFSET 25 ROWS 10 SELECT " ", " ", " " FROM " " ORDER BY " ", " " OFFSET 25 ROWS FETCH FIRST 10 ROWS ONLY 10 ORDER BY SELECT " ", " ", " " FROM " " ORDER BY " ", " " OFFSET 25 ROWS FETCH FIRST 10 ROWS WITH TIES FOR UPDATE FOR UPDATE SQL FOR UPDATE [OF ] 2,000,000 SELECT * FROM " " WHERE " " > FOR UPDATE OF " ", " ", " "

13 2 13 SQL SELECT 'CatDog' FROM " " SELECT 999 FROM " " SELECT DATE ' ' FROM " " SELECT TIME '02:49:03' FROM " " SELECT TIMESTAMP ' :49:03' FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " SELECT " " FROM " " SELECT DISTINCT " " FROM " " BLOB a SELECT " " FROM " " SELECT GETAS(" ", 'JPEG') FROM " " * SELECT * FROM " " SELECT DISTINCT * FROM " " a. BLOB FileMaker FileMaker *SELECT * FROM " " SELECT DISTINCT * FROM " " 1 FileMaker SELECT * FROM WHERE c ='' SELECT * FROM WHERE c <>'' 1 SELECT GetAs() CAST() GetAs() CAST() GetAs() JPEG GetAS(" ", 'JPEG') SELECT SELECT < >

14 2 14 QuickTime SELECT CAST() SELECT CAST( " " AS VARCHAR("NNN")) FROM " " 1 FileMaker Pro SELECT SQL_VARCHAR 1 FileMaker Pro SELECT 1 SELECT?FileMaker Pro.dat GetAs() DEFAULT DEFAULT SELECT GetAs(" ", 'DEFAULT') FROM " " FileMaker Pro GetAs() 1 [ ] > [...] GetAs () FILE SELECT GetAs(" ", 'FILE') FROM " " 1 [ ] > [...] - MAC OS X GetAs() snd SELECT GetAs(" ", 'snd') FROM " " 1 [ ] > [...] ( ) SELECT GetAs(" ", 'JPEG') FROM " " 'GIFf' Graphics Interchange Format 'PNTG' MacPaint 'JPEG' '.SGI' 'JP2' JPEG 2000 'TIFF' 'PDF' Portable Document Format 'TPIC' Targa 'PNGf' Bitmap '8BPS' PhotoShop (PSD)

15 2 15 DELETE DELETE DELETE DELETE FROM [ WHERE { } ] WHERE WHERE DELETE DELETE FROM " " WHERE " " = 'E10001' DELETE WHERE E10001 INSERT INSERT 1 1 SELECT INSERT INSERT INTO [(,...)]VALUES (,...) VALUES [4] ' : 'Don''t' () INSERT INTO " " ( " ", " ", " ", " ", " " ) VALUES (' ', ' ', 'E22345', , DATE ' ') INSERT INSERT PutAs() INSERT INTO " " (" ") VALUES(? AS '. ') FILE

16 2 16 PutAs() PutAs(col, ' ') 13 CAST() GetAs() SELECT SELECT INSERT SELECT INSERT INSERT INTO " 1" ( " ", " ", " ", " ", " " ) SELECT " ", " ", " ", " ", " " FROM " " WHERE " " = 'D050' INSERT SELECT INSERT SELECT SELECT INSERT INSERT/UPDATE ODBC JDBC SELECT INSERT SELECT UPDATE UPDATE UPDATE UPDATE SET =,...[ WHERE { } ] ' : 'Don''t' () WHERE UPDATE UPDATE " " SET " " =32000, " " =1 WHERE " " = 'E10001' UPDATE WHERE E10001 UPDATE " " SET " " = (SELECT avg( " " ) from " " ) WHERE " " = 'E10001'

17 2 17 E10001 UPDATE PutAs() UPDATE " " SET(" ") =? AS '. ' FILE PutAs() PutAs(col, ' ') 13 CAST() GetAs() CREATE TABLE CREATE TABLE CREATE TABLE CREATE TABLE ( [,...]) [DEFAULT ] [UNIQUE NOT NULL PRIMARY KEY GLOBAL] [EXTERNAL [SECURE OPEN ]] 1 [4] CREATE TABLE CREATE TABLE " " (ID INT PRIMARY KEY, " " VARCHAR(20), " " VARCHAR(20)) 1 NUMERICDECIMALINTDATETIMETIMESTAMPVARCHAR CHARACTER VARYINGBLOBVARBINARYLONGVARBINARY BINARY VARYING NUMERIC DECIMAL DECIMAL(10,0)TIME TIMESTAMP TIMESTAMP(6)VARCHAR CHARACTER VARYING VARCHAR(255) 1 DEFAULT USERUSERNAMECURRENT_USERCURRENT_DATECURDATE CURRENT_TIMECURTIMECURRENT_TIMESTAMPCURTIMESTAMP NULL 1 UNIQUE FileMaker [ ] 1 NOT NULL FileMaker [ ] FileMaker Pro [ ] [ ] [ ]

18 BLOBVARBINARY BINARY VARYING 1 EXTERNAL FileMaker FileMaker Pro [ ] SECURE OPEN / SQL CREATE TABLE "T1" ("C1" VARCHAR, "C2" VARCHAR (50), "C3" VARCHAR (1001), "C4" VARCHAR (500276)) NOT NULL CREATE TABLE "T1NN" ("C1" VARCHAR NOT NULL, "C2" VARCHAR (50) NOT NULL, "C3" VARCHAR (1001) NOT NULL, "C4" VARCHAR (500276) NOT NULL) CREATE TABLE "T2" ("C1" DECIMAL, "C2" DECIMAL (10,0), "C3" DECIMAL (7539,2), "C4" DECIMAL (497925,301)) CREATE TABLE "T3" ("C1" DATE, "C2" DATE, "C3" DATE, "C4" DATE) CREATE TABLE "T4" ("C1" TIME, "C2" TIME, "C3" TIME, "C4" TIME) CREATE TABLE "T5" ( "C1" TIMESTAMP, "C2" TIMESTAMP, "C3" TIMESTAMP, "C4" TIMESTAMP) CREATE TABLE "T6" ("C1" BLOB, "C2" BLOB, "C3" BLOB," C4" BLOB ) CREATE TABLE "T7" ("C1" BLOB EXTERNAL 'Files/MyDatabase/' SECURE) CREATE TABLE "T8" ("C1" BLOB EXTERNAL 'Files/MyDatabase/' OPEN 'Objects') ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ADD [COLUMN] ALTER TABLE DROP [COLUMN] ALTER TABLE ALTER [COLUMN] SET DEFAULT ALTER TABLE ALTER [COLUMN] DROP DEFAULT ALTER TABLE SQL ALTER TABLE " " ADD " 1" VARCHAR ALTER TABLE " " DROP " 1" ALTER TABLE " " ALTER " " SET DEFAULT 'FileMaker' ALTER TABLE " " ALTER " " DROP DEFAULT SET DEFAULT DROP DEFAULT

19 2 19 CREATE INDEX CREATE INDEX CREATE INDEX CREATE INDEX ON. CREATE INDEX ON ( ) CREATE INDEX FileMaker FileMaker [ ] [ ] FileMaker [ ] [ ] FileMaker [ ] [ ] FileMaker CREATE INDEX CREATE INDEX ON. DROP INDEX DROP INDEX DROP INDEX DROP INDEX ON. DROP INDEX ON ( ) FileMaker SELECT FileMaker [ ] [ ] [ ] PREVENT INDEX CREATION DROP INDEX ON " "." "

20 2 20 SQL SELECT WHERE HAVING ORDER BY * ' : 'Don''t' ODBC JDBC FileMaker {} ODBC/JDBC 1 {D ' '} 1 {T '14:35:10'} 1 {TS ' :35:10'} FileMaker (DTTS) FileMaker SQL-92 ISO 1 DATE 'YYYY-MM-DD' 1 TIME 'HH:MM:SS' 1 TIMESTAMP 'YYYY-MM-DD HH:MM:SS' FileMaker Pro [ExecuteSQL] {} SQL-92 ISO

21 ' ' DATE ' ' { D ' ' } {06/05/2012} {06/05/12} ODBC/JDBC SQL-92 TIME '14:35:10' { T '14:35:10' } {14:35:10} TIMESTAMP ' :35:10' { TS ' :35:10'} {06/05/ :35:10} {06/05/12 14:35:10} FileMaker [ 4 ] ODBC/JDBC SQL-92 SELECT "column1" / 3.4E+7 FROM "table1" WHERE "calc" < 3.4E-6 * "column2" +-*/ ^ ** ' ' - - ' '

22 2 22 DATE ' ' DATE ' ' - - DATE ' ' DATE ' ' SELECT " ", " " + 30 AS " " FROM " " SELECT " ", " " - 30 AS " " FROM " " = <> > >= < <= LIKE NOT LIKE IS NULL IS NOT NULL BETWEEN IN NOT IN EXISTS ANY ALL =<>>>=< <= =Any In =<>>>=< <= SELECT " "." " FROM " " WHERE " "." " = 'SP-1' SELECT " "." " FROM " " WHERE " "." " <> 125 SELECT " "." " FROM " " WHERE " "." " >

23 2 23 SELECT " "." " FROM " " WHERE " "." " < '12:00:00' SELECT " "." " FROM " " WHERE " "." " LIKE '% ' SELECT " "." " FROM " " WHERE " "." " NOT LIKE '% ' SELECT " "." " FROM " " WHERE " "." " IS NULL SELECT " "." " FROM " " WHERE " "." " IS NOT NULL SELECT " "." " FROM " " WHERE " "." " BETWEEN 1 AND 10 SELECT COUNT( " "." " ) AS " " FROM " " WHERE " "." " IN (50,250,100) SELECT COUNT( " "." " ) AS " " FROM " " WHERE " "." " NOT IN (50,250,100) SELECT COUNT ( " "." " ) AS " " FROM " " WHERE " "." " NOT IN (SELECT " "." " FROM " " WHERE " "." " = 'SP-4') SELECT * FROM " " WHERE EXISTS (SELECT " "." " FROM " " WHERE " "." " IS NOT NULL) SELECT * FROM " " WHERE " "." " = ANY (SELECT " "." " FROM " " WHERE " "." " = 'SP-1') SELECT * FROM " " WHERE " "." " = ALL (SELECT " "." " FROM " " WHERE " "." " IS NULL) AND OR = AND = 1 NOT NOT ( = AND = 1) SELECT * FROM " " WHERE " "." " NOT LIKE '% ' AND " "." " > SELECT * FROM " " WHERE ( " "." " LIKE '% ' OR " "." " > ) AND " "." " = 'SP-1'

24 ^, ** 3 *, / 4 +, - 5 =, <>, <, <=, >, >=, Like, Not Like, Is Null, Is Not Null, Between, In, Exists, Any, All 6 Not 7 AND 8 OR WHERE (" " > OR " " > (DATE ' ') AND " " = 'D101' AND D101 4,000,000 WHERE (" " > OR " " > DATE ' ') AND " " = 'D101' 4,000, D101 SQL FileMaker SQL SELECT AVG( " " ) AVG( " " * 1.07) DISTINCT COUNT (DISTINCT " " ) SUM AVG SUM AVG

25 2 25 COUNT MAX MIN COUNTCOUNT COUNT COUNT(*) MAX MIN SELECT SUM ( " "." " ) AS " " FROM " " SELECT AVG ( " "." " ) AS " " FROM " " SELECT COUNT ( " "." " ) AS " " FROM " " SELECT MAX ( " "." " ) AS " " FROM " " WHERE " "." " < SELECT MIN ( " "." " ) AS " " FROM " " WHERE " "." " > CHR ASCII CHR(67) C CURRENT_USER DAYNAME ID RTRIM RTRIM(' ABC ') ABC TRIM TRIM(' ABC ') ABC LTRIM LTRIM(' ABC') ABC UPPER UPPER('Allen'ALLEN LOWER LOWER('Allen') allen LEFT LEFT('Mattson',3Mat MONTHNAME RIGHT RIGHT(Mattson', 4) tson SUBSTR SUBSTRING SUBSTR('Conrad', 2, 3) onr SUBSTR('Conrad', 2) onrad SPACE SPACE(5) STRVAL STRVAL('Woltman') Woltman STRVAL(5 * 3) 15 STRVAL(4 = 5) False STRVAL(DATE ' ') TIME TIMEVAL USERNAME USER ID 9:49 TIME() 21:49:00 TIME() SQL CURRENT_TIME

26 2 26 SELECT CHR(67) + SPACE(1) + CHR(70) FROM " " SELECT RTRIM(' ' + " "." " ) AS " " FROM " " SELECT TRIM(SPACE(1) + " "." " ) AS " " FROM " " SELECT LTRIM(' ' + " "." " ) AS " " FROM " " SELECT UPPER( " "." " ) AS " " FROM " " SELECT LOWER( " "." " ) AS " " FROM " " SELECT LEFT( " "." ", 5) AS " " FROM " " SELECT RIGHT( " "." ", 7) AS " " FROM " " SELECT SUBSTR( " "." ", 2, 2) + SUBSTR( " "." ", 4, 2) AS " " FROM " " SELECT SUBSTR( " "." ", 2) + SUBSTR( " "." ", 4) AS " " FROM " " SELECT SPACE(2) + " "." " AS " " FROM " " SELECT STRVAL('60506') AS " " FROM " " WHERE " "." " = 1 ABS ATAN ATAN2 CEIL CEILING x y DEG DEGREES DAY DAY(DATE ' ') 30 DAYOFWEEK DAYOFWEEK(DATE ' ') 7 MOD MOD(10, 3) 1 EXP FLOOR HOUR (e) INT INT(6.4321) 6 LENGTH LENGTH('ABC') 3

27 2 27 MONTH MONTH(DATE ' ') 1 LN LOG MAX MAX(66, 89) 89 MIN MIN(66, 89) 66 MINUTE NUMVAL PI RADIANS pi NUMVAL('123') 123 ROUND ROUND(123,456.0) 123 ROUND( ,2) ROUND( , -2) 100 SECOND SIGN SIN SQRT TAN YEAR YEAR(DATE ' ') 2013 CURDATE CURRENT_DATE CURTIME CURRENT_TIME CURTIMESTAMP CURRENT_TIMESTAMP TIMESTAMPVAL TIMESTAMPVAL(' :00:00') DATE TODAY 2013/11/21 DATE() DATEVAL DATEVAL(' ') DATE() SQL CURRENT_DATE

28 2 28 CASE WHEN CASE SELECT CASE {WHEN THEN...} [ELSE ] END " ", CASE " " WHEN 'Exports UK' THEN 'Exports UK Found' WHEN 'Home Furniture Suppliers' THEN 'Home Furniture Suppliers Found' ELSE 'Neither Exports UK nor Home Furniture Suppliers' END, " " FROM " " CASE WHEN CASE {WHEN THEN...} [ELSE ] END SELECT " ", " ", CASE WHEN " " > 3000 THEN 'Above 3000' WHEN " " < 1000 THEN 'Below 3000' ELSE 'Between 1000 and 3000' END, " " FROM " " COALESCE SELECT " ", COALESCE(" "," ") FROM NULLIF SELECT " ", NULLIF(" ", -1) " " FROM " "

29 2 29 SQL CREATE TABLE DEC create table t ("dec" numeric) ABSOLUTE ACTION ADD ALL ALLOCATE ALTER AND ANY ARE AS ASC ASSERTION AT AUTHORIZATION AVG BEGIN BETWEEN BINARY BIT BIT_LENGTH BLOB BOOLEAN BOTH BY CASCADE CASCADED CASE CAST CATALOG CHAR CHARACTER CHARACTER_LENGTH CHAR_LENGTH CHECK CHR CLOSE COALESCE COLLATE COLLATION COLUMN COMMIT CONNECT CONNECTION CONSTRAINT CONSTRAINTS CONTINUE CONVERT CORRESPONDING COUNT CREATE CROSS CURDATE CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER CURSOR CURTIME CURTIMESTAMP DATE DATEVAL DAY DAYNAME DAYOFWEEK DEALLOCATE DEC DECIMAL DECLARE DEFAULT DEFERRABLE DEFERRED DELETE DESC DESCRIBE DESCRIPTOR DIAGNOSTICS DISCONNECT DISTINCT DOMAIN DOUBLE DROP ELSE END END_EXEC ESCAPE EVERY

30 2 30 EXCEPT EXCEPTION EXEC EXECUTE EXISTS EXTERNAL EXTRACT FALSE FETCH FIRST FLOAT FOR FOREIGN FOUND FROM FULL GET GLOBAL GO GOTO GRANT GROUP HAVING HOUR IDENTITY IMMEDIATE IN INDEX INDICATOR INITIALLY INNER INPUT INSENSITIVE NSERT INT INTEGER INTERSECT INTERVAL INTO IS ISOLATION JOIN KEY LANGUAGE LAST LEADING LEFT LENGTH LEVEL LIKE LOCAL LONGVARBINARY LOWER LTRIM MATCH MAX MIN MINUTE MODULE MONTH MONTHNAME NAMES NATIONAL NATURAL NCHAR NEXT NO NOT NULL NULLIF NUMERIC NUMVAL OCTET_LENGTH OF OFFSET ON ONLY OPEN OPTION OR ORDER OUTER OUTPUT OVERLAPS PAD PART PARTIAL PERCENT POSITION PRECISION PREPARE PRESERVE PRIMARY PRIOR PRIVILEGES PROCEDURE PUBLIC READ REAL REFERENCES RELATIVE RESTRICT REVOKE RIGHT ROLLBACK ROUND ROW ROWID ROWS RTRIM SCHEMA SCROLL SECOND SECTION SELECT SESSION SESSION_USER

31 2 31 SET SIZE SMALLINT SOME SPACE SQL SQLCODE SQLERROR SQLSTATE STRVAL SUBSTRING SUM SYSTEM_USER TABLE TEMPORARY THEN TIES TIME TIMESTAMP TIMESTAMPVAL TIMEVAL TIMEZONE_HOUR TIMEZONE_MINUTE TO TODAY TRAILING TRANSACTION TRANSLATE TRANSLATION TRIM TRUE UNION UNIQUE UNKNOWN UPDATE UPPER USAGE USER USERNAME USING VALUE VALUES VARBINARY VARCHAR VARYING VIEW WHEN WHENEVER WHERE WITH WORK WRITE YEAR ZONE

32 A ABS 26 ALL 22 ALTER TABLE (SQL ) 18 AND 23 ANY 22 ATAN 26 ATAN2 26 B BETWEEN 22 BLOB SELECT 13 C CASE WHEN 28 CAST 14 CEIL 26 CEILING 26 CHR 25 COALESCE 28 CREATE INDEX (SQL ) 19 CREATE TABLESQL 17 CURDATE 27 CURRENT USER 25 CURRENT_DATE 27 CURRENT_TIME 27 CURRENT_TIMESTAMP 27 CURRENT_USER 25 CURTIME 27 CURTIMESTAMP 27 D DATE 27 DATEVAL 27 DAY 26 DAYNAME 25 DAYOFWEEK 26 DEFAULT (SQL ) 17 DEG 26 DEGREES 26 DELETESQL 15 DISTINCT 8 DROP INDEX SQL 19 E ExecuteSQL 6, 7 EXISTS 22 EXP 26 EXTERNAL (SQL ) 18 F FETCH FIRSTSQL 12 FLOOR 26 FOR UPDATESQL 12 FROMSQL 9 FULL OUTER JOIN 9 G GetAs 14 GROUP BYSQL 10 H HAVINGSQL 10 HOUR 26 I IN 22 INNER JOIN 9 INSERTSQL 15 INT 26 IS NOT NULL 22 IS NULL 22 J JDBC Unicode 7 7 L LEFT OUTER JOIN 9 LEFT 25 LENGTH 26 LIKE 22 LN 27 LOG 27 LOWER 25 LTRIM 25 M MAX 27 MIN 27 MINUTE 27 MOD 26 MONTH 27 MONTHNAME 25

33 33 N NOT IN 22 NOT LIKE 22 NOT NULLSQL 17 NOT 23 NULLIF 28 NUMVAL 27 O ODBC Unicode 7 7 ODBC 7 ODBC 12 OFFSETSQL 11 OR 23 ORDER BYSQL 11 OUTER JOIN 9 P PI 27 PREVENT INDEX CREATION 19 PutAs 15, 17 R RADIANS 27 RIGHT OUTER JOIN 9 RIGHT 25 ROUND 27 RTRIM 25 S SECOND 27 SELECTSQL 8 BLOB SIGN 27 SIN 27 SPACE 25 SQL SQL 24 SQL 21 SQL 24 SQL 21 SQL 21 SQL 20 SQL 22 SQL 20 SQL 21 SQL 22 SQL 23 SQL SELECT 8 ALTER TABLE 18 CREATE INDEX 19 CREATE TABLE 17 DELETE 15 DROP INDEX 19 INSERT 15 UPDATE SQL 24 SQL 7 SQL_C_WCHAR 7 SQL-92 7 SQL 20 SQRT 27 STRVAL 25 SUBSTR 25 SUBSTRING 25 T TAN 27 TIME 25 TIMESTAMPVAL 27 TIMEVAL 25 TODAY 27 TRIM 25 U Unicode 7 UNIONSQL 11 UNIQUE (SQL ) 17 UPDATE (SQL ) 16 UPPER 25 USERNAME 25 V VALUES SQL 15 W WHERESQL 9 WITH TIESSQL 12 Y YEAR 27

34 34 12 CREATE TABLE 18 GetAs 14 INSERT 15 PutAs 15 SELECT 13 UPDATE SELECT 13 SQL SQL , 9 SQL SELECT 13